Reverse the sign of a number in a cell
If you want to reverse negative/postive, put -1 in an empty cell, copy it,
select the numbers, do editpaste special and select mulitply Regards, Peo Sjoblom "epowell74" wrote: I'd like to create a formula that I can use to reverse the sign of a number. The problem I'm having is that the formula cannot contain a reference to the cell itself because it then loses the value. I realize that I can do this through VBA, but I wondered if there was another way to do this. It seems like this would be a fairly common thing to do. Thanks in advance for your help! |
All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com