Rounding

  • Thread starter Thread starter uplink600
  • Start date Start date
U

uplink600

Good Afternoon

I have a range of cells on a worksheet that I need rounding up to th
nearest multiple of 6.00.

ie 5.75 should be 6.00
16.95 should be 18.00
23.11 should be 24.00 etc etc

Can someone advise an easy way to do this.

Thanks

V
 

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

Rounding Down 2
IF & AND Function 5
Trying Rounding 3
adding the same formula to several cells without changing cell lin 7
How can I apply the ROUND function to a range of cells in a workbo 5
nearest round figure 10
Excel is not rounding properly. 4
Rounding 5

Back
Top