return a negative value

[Guest]

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

 

[Guest]

Try something like this:

=-ABS(SUM(A1:A10))

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

XL2002, WinXP