Hi Peo,

For some reason this solution still does not round up. I apologise for
forgetting to mention rounding up. The solution Rick provided does work for
me. Thank you so much for your help.
--
Gary in Michigan, USA


"Peo Sjoblom" wrote:

It was because you stated in your subject line that you wanted nearest which
is what I gave you, but after looking at your example it was obvious you
wanted to round up

=MAX(CEILING((E5+G5)*1.25,10)-1,0)

will round up


--


Regards,


Peo Sjoblom


"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