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