AnsweredAssumed Answered

Number Rounding Help (rounding dollar amounts)

Question asked by carfiles on Feb 24, 2012
Latest reply on Feb 24, 2012 by carfiles

I have the need to find a calculation that rounds a dollar amount to the next hundredth, for instance $1,722.31 needs to convert to $1,800.00 and so on.

I have tried the Ceiling ( ) formulation but it only rounds up to the next dollar. I've also experimented with Round (Floor ( );-2) then adding 100, for some reason my system seems to slow down to a crawl with that formula.

Any help will be greatly appreciated,

Thanks...Gary

Outcomes