ExcelBanter - I want to subtract a number from an entire row in excel

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

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

- - I want to subtract a number from an entire row in excel (https://www.excelbanter.com/excel-worksheet-functions/217017-re-i-want-subtract-number-entire-row-excel.html)

David Biddulph[_2_]

I want to subtract a number from an entire row in excel

Put 2000 in a spare cell, copy, select your row, Edit/ Paste Special/
Subtract/ OK
You can now delete the 200 from the spare cell, if you wish.
--
David Biddulph

"kav" wrote in message
...
I want to subtract a constant number say 2000 fro an entire row and replace
the same row with the new answer

All times are GMT +1. The time now is 05:46 AM.