ABS and MOD in Excel - Cell-by-Cell Formula Trace

Sample Data

Column A has some positive and negative numbers. Column B has positive divisors for MOD function.

Cell	Value
A1	-15
A2	7
A3	-3
B1	4
B2	5
B3	2

Formula Trace

=ABS(A1) + MOD(A2, B2) + ABS(A3) + MOD(A3, B3)

Step 1: ABS(A1)

Step 2: MOD(A2, B2)

Step 3: ABS(A3)

Step 4: MOD(A3, B3)

Step 5: 15 + 2 + 3 + 1

Cell Reference Map

    A    B
1  -15   4
2   7    5
3  -3    2

Formula uses A1, A2, A3, B2, B3 cells.

The formula references cells A1, A2, A3 for values and B2, B3 as divisors for MOD.

Result

    A    B    C
1  -15   4   21
2   7    5
3  -3    2

Cell C1 shows the formula result 21.

The formula result 21 is displayed in cell C1 after calculating ABS and MOD functions.

Sheet Trace Quiz - 3 Questions

What is the result of ABS(A1) if A1 is -15?

A 15

B -15

C 0

D -1

Key Result

ABS returns positive value; MOD returns positive remainder of division.