ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Convert a negative result to a positive result (https://www.excelbanter.com/excel-programming/280139-re-convert-negative-result-positive-result.html)

Chip Pearson

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.





All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com