Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.worksheet.functions




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




Answer: HELP! Need to divide all columns by same number to get sell price
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.worksheet.functions




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 clickPaste 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  


Similar Threads  
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) 