I am trying to have a calculated cost  - ie.  Ic most recent * 1.8 rounded up to the next 100.  Say I get 2445 that would print 2500 and then I am trying to substruct 1.00 from 2500 to get a new sales price of 2499.  I am using two formulas one to get the 2500 and then another to get the 2499.  I think my problem is I can get the 2500 to print out by formatting to the 100 but when I used that to substract the 1.00 I get the pre-rounded amount -1.00.  

I also tried the Round function but icant seem to get it to round up to the next 100? 

Any suggestions would be much appreciated.  

Thks