| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert a negative result to a positive result
Tom,
Take a look at the ABS function, which returns the absolute (positive) value of a number. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... How do you convert a negative answer in a formula to a positive answer? I am dividing a positive number by a negative number but want the percentage answer to be a positive number. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative Numbers Have Positive Result | Excel Discussion (Misc queries) | |||
| Finding minum positive from the result of formula | Excel Discussion (Misc queries) | |||
| How can I add a + sign to a positive result of a calculation? | Excel Discussion (Misc queries) | |||
| Cell formula where result to be Positive only | Excel Discussion (Misc queries) | |||
| Convert positive # to negative | Excel Discussion (Misc queries) | |||
Linear Mode
