Answer must always be negative.

  • Thread starter Thread starter Shhhh
  • Start date Start date
S

Shhhh

Hello all...

I have a fairly straight forward formula:

=sum((F29-E29)*(C29*D29))

When the resulting answer is negative I'm very happy... but when the
result comes back positive, I need to make it negative... How can I go
about doing this??


Thank you very much!!
Shhhh
 
You could amend your formula to this:

=-ABS(sum((F29-E29)*(C29*D29)))

Hope this helps.

Pete
 
=sum((F29-E29)*(C29*D29))

As a side note, I don't see anything being "Summed."
Did you mean Product?

= -ABS(PRODUCT(C29,D29,F29-E29))
 
Back
Top