How to apply rounding across a range of cells with other formulae

G

Guest

I have a payroll spreadsheet for a school canteen set up on Excel and want to
be apply to use just 2 decimal places. I can get the display right but the
calculations carry the full value forward resulting in rounding errors.
I have used the ROUND function to get rid of these but I have to apply this
to each cell as required, and would like to find out
1- how to apply the ROUND function to a whole spreadsheet or a range
without doing each cell separately
2- a better way to do it.
The solution requires more than just changing the number displayed.
 
G

Guest

format for 2 decimal places then use

Tools>Options>Calculation
Workbook Options>Precision as Displayed check the box

warning this resets entire workbook and drops all decimal places not shown
what you asked for, but be carefull what you ask for
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I apply a rounding rule 13
Formula Rounding 1
How to get range names to Apply across multiple tabs 1
Rounding Existing Formulas/Values 1
How do i apply Goal Seek to a range of cells in Excel 1
Rounding problem 9
How do I apply a formula to #s already typed in a series of cells 1
How do I apply the ROUNDUP formula to a range of calculated data 1

Top