Rounding to nearest 9
You didn't say what you wanted to happen for values above the "9 value"
but less than the "0 value"; for example, what do you want $3249.50 to
"round" to?
Depending on your answer to my question, this formula **may** do what you
want...
=10*ROUNDUP((A1+(MOD(A1,10)=0))/10,0)-1
Of course you will want to replace my A1 references with (E5+G5)*1.25.
Rick
|