A
Air2000
I have entered the formula in my cell, and I want my result to be rounded to
the nearest multiple of signifiance (for example 5). I have tried with
function CEILING and FLOOR, but these functions only rounds number
UP(ceiling) or DOWN(floor), so for this I have to know what my result is to
rounded it. That is not the solution, I would like for Excel to do it
automaticaly. Here is example:
If my result is say 117.49 and lower (to the limit of 115), I want to round
it to 115, if result is 117.51 and higher (to the limit of 120) to round to
120...(multiple of significance is 5).
Can it be done?
Rgds
the nearest multiple of signifiance (for example 5). I have tried with
function CEILING and FLOOR, but these functions only rounds number
UP(ceiling) or DOWN(floor), so for this I have to know what my result is to
rounded it. That is not the solution, I would like for Excel to do it
automaticaly. Here is example:
If my result is say 117.49 and lower (to the limit of 115), I want to round
it to 115, if result is 117.51 and higher (to the limit of 120) to round to
120...(multiple of significance is 5).
Can it be done?
Rgds