|re: if num= 9.15, result= 9.1|
I don't know if you know this or not, but that is not the "standard". The vast majority of applications and mathematicians use the "round half towards positive infinity" rule for deciding how to round numbers that end in 5.
When that rule is applied, 9.15 would be rounded up and the answer would be 9.2.
If you want to use Excel's round function, but still round 9.15 to 9.1, you might be able to use this:
Depending on the precision of your actual values, this might work for you or it might not.
Please let us know.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03