round function?

[dalee]

spread sheet: items are listed in rows. column (a) is a list of prices for individual items, column (b) is a list of case prices, formula for column (b) is =a1*12 or a2*6. There are different multipliers in column (b)'s cells. I need to increase prices via dividing column (a) by 0.9. When this is done many cells in column (a) are several decimal places. This makes Column (b) value incorrect because ithe formula uses the actual cell value and not the rounded value I have formatted for column (a)'s cells. How would can change column (b)'s value to reflect the rounded number in column (a) without going into each cell in column b and use the ROUND function? Remember there are different multipliers in column (b)'s cells.

 

[Joe4]

Go into the Tools drop down menu, select Options and go to the Calculation tab. Under the Workbook Options, select "Precision as Displayed"