UserForm basics in Excel - Cell-by-Cell Formula Trace

Sample Data

Sample data table with names and ages to be used with a UserForm for data entry.

Cell	Value
A1	Name
B1	Age
A2	Alice
B2	30
A3	Bob
B3	25
A4	Carol
B4	28

Formula Trace

=IF(B2>27, "Adult", "Young")

Step 1: B2

Step 2: 30 > 27

Step 3: IF(TRUE, "Adult", "Young")

Cell Reference Map

    A       B
1 | Name  | Age  |
2 | Alice |  30  | <-- referenced by formula
3 | Bob   |  25  |
4 | Carol |  28  |

The formula references cell B2 which contains the age value for Alice.

Result

    A       B       C
1 | Name  | Age  | Status |
2 | Alice |  30  | Adult  |
3 | Bob   |  25  |        |
4 | Carol |  28  |        |

The formula in cell C2 evaluates the age in B2 and outputs 'Adult' because 30 is greater than 27.

Sheet Trace Quiz - 3 Questions

What does the formula =IF(B2>27, "Adult", "Young") return when B2 is 30?

A Young

B 30

C Adult

D FALSE

Key Result

IF(condition, value_if_true, value_if_false) returns one of two values based on a condition.