Excel Forum



Excel Magic Trick # 164: CEILING function in Price Formula


See how to how to use the IF and CEILING functions in one formula to calculate the Price for shipping. The CEILING function is a great solution when you need to always round to a certain amount, like $0.50 ($0.50, $1.00, $1.50, etc.).





Got a Question? Ask it Here in the Forum.