Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
GolfGal
 
Posts: n/a
Default 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   Report Post  
Niek Otten
 
Posts: n/a
Default

(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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM
Is there a formula to spell out a number in excel? Sha-nay-nay Excel Worksheet Functions 2 December 18th 04 09:25 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM
Spellnumber Norman Jones Excel Worksheet Functions 6 December 13th 04 07:21 AM


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"