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.
Bookmarks