DIVIDE for safe division in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows numerators and denominators for division. Some denominators are zero to test safe division.

Cell	Value
A1	Numerator
B1	Denominator
A2	100
B2	20
A3	50
B3	0
A4	0
B4	10

Formula Trace

DIVIDE(A2, B2, 0)

Step 1: Numerator = A2

Step 2: Denominator = B2

Step 3: Check if Denominator = 0

Step 4: Divide Numerator by Denominator: 100 / 20

Step 5: Result = 5

Cell Reference Map

    A       B
1 Numerator Denominator
2   100  -->  20
3    50  -->   0
4     0  -->  10

The formula uses values from cells A2 (numerator) and B2 (denominator). The arrow shows the flow of values into the DIVIDE function.

Result

    A       B       C
1 Numerator Denominator Result
2   100       20       5
3    50        0       0
4     0       10       0

Column C shows the result of DIVIDE for each row. For row 2, 100 divided by 20 equals 5. For row 3, denominator is zero, so DIVIDE returns the alternate result 0 safely.

Sheet Trace Quiz - 3 Questions

What does DIVIDE(50, 0, 0) return?

A 0

B Infinity

C Error

D 50

Key Result

DIVIDE(numerator, denominator, alternateResult) returns numerator/denominator or alternateResult if denominator is zero.