Exercise catalogue
Choose a category
Pick a topic, then a function. Each exercise opens a real spreadsheet: type the formula, check your answer, and get a hint if you’re stuck.
301 exercises0 completed
One value if true, another if false.
How IF worksIFStock Reorder CheckUse IF to decide whether to reorder an item when its stock falls below 20 units.BeginnerNot startedIFTemperature AdvisoryUse IF to show "Hot" when the temperature is above 30, otherwise "Cool".BeginnerNot startedIFFree Shipping FlagUse IF to mark an order as "Free" when the order total is at least 50, otherwise "Paid".BeginnerNot startedIFPass or Fail by ScoreUse IF to label each student's score as Pass or Fail based on a passing mark of 60.BeginnerNot startedIFBonus EligibilityUse IF to return a numeric bonus of 100 when sales reach 500, otherwise 0.BeginnerNot startedIFBonus with Optional False ArgumentUse IF with the optional value_if_false omitted so it returns FALSE when the condition fails.IntermediateNot startedIFIF Combined with SUMUse IF with SUM to compare a total against a target.IntermediateNot startedIFIF Combined with ANDCombine IF with AND to require two conditions before returning a result.IntermediateNot startedIFIF Combined with COUNTIFUse IF with COUNTIF to check how many entries meet a criterion.IntermediateNot startedIFPass or Fail with Nested IFUse IF with a nested IF to assign a grade band based on a score.IntermediateNot startedIFDiscount by Order ValueAn online store gives a 15% discount on orders of 200 or more, otherwise no discount.AdvancedNot startedIFStock Reorder FlagA warehouse flags items whose stock falls below the reorder point with a text status.AdvancedNot startedIFGrade with Nested ThresholdA training center assigns Pass or Fail based on a score of 70, and adds a bonus label for top scores.AdvancedNot startedIFOvertime Pay CalculationA payroll sheet pays 1.5 times the hourly rate for hours above 40 and normal rate otherwise.AdvancedNot startedIFSales Commission TierA sales team earns a 10% commission on sales above 5000, otherwise a flat 150 bonus.AdvancedNot started