If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP! Need to divide all columns by same number to get sell price
I have a net cost sheet. I want to divide each of the 7 columns (which each
have different values) by one number to get my sell price. When I looked at the MOD function, it asked for the number in the cell and then my division number. Do I have to do this manually for each cell or is there a way I can do a formula applying division to each of cells at one time? |
#2
|
|||
|
|||
HELP! Need to divide all columns by same number to get sell price
suppose you want to divide all columns with 5.
1. Enter 5 in a different cell 2. copy the cell 3. Select the columns/values which are to be divided. 4. Right click-Paste Special. 5. Select 'divide' and OK/ -- If this post helps click Yes --------------- Jacob Skaria "twoods403" wrote: I have a net cost sheet. I want to divide each of the 7 columns (which each have different values) by one number to get my sell price. When I looked at the MOD function, it asked for the number in the cell and then my division number. Do I have to do this manually for each cell or is there a way I can do a formula applying division to each of cells at one time? |
Thread Tools | |
Display Modes | |
|
|