Compute the shipping fee per order before the receipts email
Free shipping on orders $100 and up — $9.99 flat on everything below. Your invoice generator reads column C for the fee, so we need a formula that pulls the right number from the threshold in B.
Free shipping over $100, $9.99 otherwise
Practice using IF to solve a real small business problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
The store's promotion is simple: free shipping on orders of $100 or more, $9.99 flat on everything below. Your invoice generator needs the shipping fee computed per row before it emails the receipt.
In cell C2, return 0 when the order total in B2 is at least 100. Otherwise return 9.99. Output is a number, not a string. Drag the formula down through C9 so every order has its fee.
IF tests a condition and returns one value if it's true and another if it's false. It's the foundation of every conditional formula in Excel. The condition can use comparison operators (=, <, >, <>), and the two return values can be numbers, text, blanks, or even nested formulas.
IF(logical_test, value_if_true, [value_if_false])Try the formula first. Hints cost CP for a reason.