IF function for conditions in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales amounts in column A and empty Bonus column B to calculate bonus based on sales.

Cell	Value
A1	Sales
A2	500
A3	1500
A4	800
B1	Bonus
B2
B3
B4

Formula Trace

IF(A2 > 1000, "Bonus", "No Bonus")

Step 1: A2 > 1000

Step 2: 500 > 1000

Step 3: IF(FALSE, "Bonus", "No Bonus")

Cell Reference Map

    A       B
1 | Sales | Bonus |
2 |  500  |       |
3 | 1500  |       |
4 |  800  |       |

Arrow: A2 -> formula condition check

The formula checks the value in cell A2 to decide the bonus.

Result

    A       B
1 | Sales | Bonus    |
2 |  500  | No Bonus |
3 | 1500  |          |
4 |  800  |          |

The formula result "No Bonus" is placed in cell B2 because sales in A2 is 500 which is not greater than 1000.

Sheet Trace Quiz - 3 Questions

What does the condition A2 > 1000 evaluate to when A2 is 500?

A 500

B TRUE

C FALSE

D 1000

Key Result

IF(condition, value_if_true, value_if_false) returns value based on condition TRUE or FALSE.