| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to subtract a number from an entire row in excel
you can use this formula also for eg your data is in row A1 and you want your
answer in row A2 =A1-2000 Then you can copy row A2 and right click on row A1 paste specialvalues. This will replace the same row with a substracted value. -- _______________________ Click "Yes" button if it helps ________ Thanks Suleman Peerzade "kav" wrote: I want to subtract a constant number say 2000 fro an entire row and replace the same row with the new answer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I subtract excel cell values that contain both a number a. | Excel Discussion (Misc queries) | |||
| I want to subtract a number from an entire row in excel | Excel Worksheet Functions | |||
| How do I add the same number/value for an entire column in Excel? | Excel Worksheet Functions | |||
| how can i subtract single integer value from the entire column | Charts and Charting in Excel | |||
| Subtract entire sheet? | Excel Worksheet Functions | |||
![Suleman Peerzade[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
