Hi all,

I have a cell that you enter a volume size, and depending on what is entered, a calculation is performed. In order to try an keep the calculation to a simple thing, I need to round the volume size first. I need it rounded to either .0 or .05 ...

For example. Volume Size is 2.43, this requires to be rounded up to 2.5 for a maximum size and rounded down to 2.0 for a minimum size.
The volume size can vary from 0.00 upto 3.00, a max and min require to be calculated for this with a 0.05 tolerance.

Whats my best options of doing this?

Any help greatly appreciated - its doing my head in!!!

Peter.