Thread
:
Convert a negative result to a positive result
View Single Post
#
1
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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 With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson