Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FunctionRookie
 
Posts: n/a
Default Is there an opposite function of SUM, like DIFF?

How do I get the Difference between f20 and f21 and use it in a formula. Say
f20's value is $17.27 and f21's value is $17.32 and I want to multiply that
difference to a value in f22 of $10,500.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Is there an opposite function of SUM, like DIFF?

"FunctionRookie" wrote:
How do I get the Difference between f20 and f21 and
use it in a formula.


Simply "f20 - f21" or "f21 - f20", depending on your intent.

By the way, you could simply write do "f20 + f21" instead
of SUM(f20:f21).

And to answer the question in your subject line, the
"opposite" of SUM(a1,...) is simply -SUM(a1,...) or
a1-SUM(...), depending on your intent.

Say f20's value is $17.27 and f21's value is $17.32
and I want to multiply that difference to a value in
f22 of $10,500.


I think you mean "multiply by". Depending on your intent,
try:

=(f21-f20)*f22

or

=(f20-f21)*f22
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
What function is the opposite of SUM? rsilver Excel Discussion (Misc queries) 4 November 19th 05 06:56 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 11:34 AM.

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

About Us

"It's about Microsoft Excel"