View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.