ExcelBanter - reverse value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - reverse value (https://www.excelbanter.com/excel-worksheet-functions/136733-reverse-value.html)

reverse value

I want to reverse value of a sum in a number of cells. I know how to change a
minus into a plus, but how can I change a positiv value to a negative?

John

reverse value

try =-A1
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

"rb" wrote:

I want to reverse value of a sum in a number of cells. I know how to change a
minus into a plus, but how can I change a positiv value to a negative?

All times are GMT +1. The time now is 02:17 PM.