ExcelBanter - return a negative value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - return a negative value (https://www.excelbanter.com/excel-discussion-misc-queries/136999-return-negative-value.html)

Mtabaruka

return a negative value

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
--
Wether you think you can or you think you cant , you are right ... anon

Ron Coderre

return a negative value

Try something like this:

=-ABS(SUM(A1:A10))

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

XL2002, WinXP

"Mtabaruka" wrote:

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
--
Wether you think you can or you think you cant , you are right ... anon

All times are GMT +1. The time now is 06:22 AM.