Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table - total sell price | Excel Discussion (Misc queries) | |||
Calculate the percentage from the cost and recommended sell price | New Users to Excel | |||
Divide date into separate columns | Excel Worksheet Functions | |||
can you count the number of letters (inc spaces) in a single sell | New Users to Excel | |||
Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) |