Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
(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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |