Rounding in Excel

[BDawg]

I'm creating a billing spreadsheet. Sometimes, when you calculate tax, you get a number like 1.001. When you use the round() or fixed() functions, excel wants to round that number to 1.00 when we need 1.01. Any way to force excel to round up?

 

[petesamprs]

Use the =ceiling( ) function

 

[MrChad]

Try the CEILING() function. In your case, you would want CEILING(1.001, 0.01).

edit: a bit too slow

 

[BDawg]

Great! Thanks everyone, that fixed the problem.