function based on result of same function

G

GolfGal

When using an extensively long formula is it possible to use some function
that is the result of that, without writing or pasting the whole formula
again?

For instance:
SUM (...)*A3/.1*c3 if this were to equal $100
and then I wanted to subract 9.75% of that same result, to then equal
$100 - (100*.0975) or 90.25
 
N

Niek Otten

(SUM (...)*A3/.1*c3)*(1-9.75%)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top