return a negative value

M

Mtabaruka

I am doing a sum but I want to always return the result as a negative value
even if its positive e.g if my result of =sum(a1:c1) is 10 I want to get the
result as -10
 
R

Ron Coderre

Try something like this:

=-ABS(SUM(A1:A10))

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top