View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
twoods403 twoods403 is offline
external usenet poster
 
Posts: 1
Default 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?