software

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.

quot;FunctionRookiequot; wrote:
gt; How do I get the Difference between f20 and f21 and
gt; use it in a formula.

Simply quot;f20 - f21quot; or quot;f21 - f20quot;, depending on your intent.

By the way, you could simply write do quot;f20 f21quot; instead
of SUM(f20:f21).

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

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

I think you mean quot;multiply byquot;. Depending on your intent,
try:

=(f21-f20)*f22

or

=(f20-f21)*f22