Is there an opposite function of SUM, like DIFF?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
FunctionRookie said:
How do I get the Difference between f20 and f21 and
use it in a formula.
Click to expand...

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.
Click to expand...

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

=(f21-f20)*f22

or

=(f20-f21)*f22
 
Back
Top