0
0
Power BIbi_tool~10 mins

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

Choose your learning style9 modes available
Sample Data

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

CellValue
A1Numerator
B1Denominator
A2100
B220
A350
B30
A40
B410
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
Test your understanding
What does DIVIDE(50, 0, 0) return?
A0
BInfinity
CError
D50
Key Result
DIVIDE(numerator, denominator, alternateResult) returns numerator/denominator or alternateResult if denominator is zero.