| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a value when the number is negative | Excel Worksheet Functions | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| Negative return in =DATEDIF function | Excel Discussion (Misc queries) | |||
| return 0 instead of a negative # | Excel Discussion (Misc queries) | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Linear Mode
