function based on result of same function
 

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

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"GolfGal" wrote in message
...
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