| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
subtract 10 from every number in a column
I am new to excel and I am trying to use it for inventory management. I am trying to subtract 10 dollars from every number in my Price column, what steps would I take to achieve this? -- gimianame ------------------------------------------------------------------------ gimianame's Profile: http://www.excelforum.com/member.php...o&userid=26203 View this thread: http://www.excelforum.com/showthread...hreadid=395066 |
|
#2
|
|||
|
|||
|
Put 10 in a cell and copy it.
Select all of the target cells Menu EditPastespecial and click Subtract in the Operation area OK -- HTH RP (remove nothere from the email address if mailing direct) "gimianame" wrote in message ... I am new to excel and I am trying to use it for inventory management. I am trying to subtract 10 dollars from every number in my Price column, what steps would I take to achieve this? -- gimianame ------------------------------------------------------------------------ gimianame's Profile: http://www.excelforum.com/member.php...o&userid=26203 View this thread: http://www.excelforum.com/showthread...hreadid=395066 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| Number of Column Limitations | Excel Discussion (Misc queries) | |||
| How do I subtract with text valued number instead of an actual num | Excel Worksheet Functions | |||
| how to subtract the very next LOWEST number | New Users to Excel | |||
Linear Mode
