Task 1 of 5
In F2:F7, enter the shipping cost: 0 if the order total is $200 or more, otherwise 15.
Lesson theory
An online store in Austin is processing orders. Practice IF, IFS, AND, OR and IFERROR.
Tip: write text in formulas in quotation marks ("Yes") and numbers without them, or the comparison will not work.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.