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
Rick
"GaryS" wrote in message
...
Peo,
This one rounds $3250 down to $3249. I need it to round $3250 to $3259.
Thanks so much for your help.
--
Gary in Michigan, USA
"Peo Sjoblom" wrote:
One possible
=MAX(ROUND(((E5+G5) * 1.25)/10,0)*10-1,0)
--
Regards,
Peo Sjoblom
"GaryS" wrote in message
...
I have the following =(E5+G5) * 1.25 which results in $1446.25. I
would
like it to be rounded to $1449.00. How could I do this? Thanks!
--
Gary in Michigan, USA
|