2 Replies Latest reply on Feb 24, 2012 6:03 PM by carfiles

    Number Rounding Help (rounding dollar amounts)

    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