Custom functions in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

Column A has numbers. Column B uses a custom function DOUBLE to multiply each number by 2.

Cell	Value
A1	5
A2	10
A3	15
B1	=DOUBLE(A1)
B2	=DOUBLE(A2)
B3	=DOUBLE(A3)

Formula Trace

=DOUBLE(A1)

Step 1: A1

Step 2: DOUBLE(5)

Cell Reference Map

    A     B
1 |  5  -> 10
2 | 10  -> 20
3 | 15  -> 30

Cells in column A are inputs to the custom function DOUBLE in column B.

Result

    A     B
1 |  5  | 10
2 | 10  | 20
3 | 15  | 30

Column B shows the doubled values of column A using the custom function DOUBLE.

Sheet Trace Quiz - 3 Questions

What does the custom function DOUBLE do to the input number?

A Multiplies the number by 2

B Adds 2 to the number

C Subtracts 2 from the number

D Divides the number by 2

Key Result

Custom functions take input cell values and return results based on user-defined logic.