The Job Tests

WORKPLACE SKILLS · PRACTICAL GUIDE

Excel IF: Test a Boundary Value, Not Only an Obvious Case

Enter a target of 100 in B1 and an achieved value of 100 in A2. You need a clear label for whether the target was reached.

The idea behind the exercise

IF chooses between two results using a logical test. Including equality in >= means that exactly reaching the target counts.

Practise Excel IF in a scratch workbook

Enter =IF(A2>=$B$1,"Met","Below") in C2.

Use a separate practice sheet rather than changing an important workbook. Keep the stated inputs visible and label the result cell. Predict the result before checking Excel so that the exercise tests your understanding instead of your ability to copy instructions.

A mistake to check

Testing only 50 and 150 would miss the difference between > and >=. The boundary case is part of the requirement.

Change one condition and test again

Add more achieved values below A2 and copy the formula down. Confirm that the reference to B1 stays fixed.

Write one sentence explaining why the result changed or stayed the same. If it differs from your prediction, inspect the entered values, the formula or selected range and the rule you intended to use. Change one thing at a time so the cause of the difference remains visible.

Version and locale notes

Examples use English function names and commas between arguments. Your regional settings may use semicolons, different decimal or date formats, or localised function names. Menu wording and feature availability can differ by Excel version; consult the provider documentation for your installation.

For provider documentation and related feature details, visit Microsoft Excel Support. The dataset and practice steps in this article are original examples from The Job Tests.

Continue with Make Your Tell Me About Yourself Answer Relevant to the Role for an earlier guide in this series.

Original educational content by The Job Tests, operated by Sasflynet Kft. No diagnosis, certification or hiring outcome is promised.

Put this guide into practice

Excel intermediate practice · Choose a free seven-day path