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