ExcelBanter - Convert a negative result to a positive result

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/280147-re-convert-negative-result-positive-result.html)

Tom Ogilvy

Convert a negative result to a positive result

=Abs(formula)

--
Regards,
Tom Ogilvy

"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 06:03 PM.