Rounding to nearest 9
Hi Guys,
Thanks. This one comes the closest, but it rounds up OR down.
=MAX(ROUND(((E5+G5) * 1.25)/10,0)*10-1,0)
I only want it to round up to the nearest 9. In other words if the results
are $3243.00 I want it rounded to $3249.00.
Thanks!
--
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
|