MS Excel
Does any one know the formula for converting positive figures to Negatives
|
=IF(A10,-A1,A1)
-- HTH Bob Phillips "Gav" wrote in message ... Does any one know the formula for converting positive figures to Negatives |
=if(a10,-a1,a1)
or ... =-abs(a1) ========== If you're careful, you can do this without formulas. Put -1 in an empty cell copy that cell select your cells to change (click on the first and ctrl-click on subsequent) edit|paste special|check multiply Clean up that helper cell with -1 in it. Gav wrote: Does any one know the formula for converting positive figures to Negatives -- Dave Peterson |
All times are GMT +1. The time now is 12:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com