NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Spreadsheet basics›Create a custom function

Google Sheets · Verified tutorial

Create a custom function in Google Sheets

This is a safe custom-function design fixture. Enter exactly "DOUBLEVALUE" in A2, "D2" in B2, and "value * 2" in C2. In E2, enter the standard Sheets formula =D2*2 so the sample output is 14. Do not open Apps Script, create executable code, or authorize a project. Keep the TAXTOTAL example unchanged.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

This is a safe custom-function design fixture. Enter exactly "DOUBLEVALUE" in A2, "D2" in B2, and "value * 2" in C2. In E2, enter the standard Sheets formula =D2*2 so the sample output is 14. Do not open Apps Script, create executable code, or authorize a project. Keep the TAXTOTAL example unchanged.

Step-by-step

1

Select the targetThis is a safe custom-function design fixture.

2

Complete the next actionEnter exactly "DOUBLEVALUE" in A2, "D2" in B2, and "value * 2" in C2.

3

Apply the changeIn E2, enter the standard Sheets formula =D2*2 so the sample output is 14.

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

The DOUBLEVALUE function design is documented, its sample calculation returns 14, and the existing TAXTOTAL example is preserved.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select A2 and repeat the final action. The DOUBLEVALUE function design is documented, its sample calculation returns 14, and the existing TAXTOTAL example is preserved.

Example spreadsheet data

This is the clean fixture used for the verified run.

Function	Input cell	Rule	Sample input	Expected output
			7
TAXTOTAL	D3	value * 1.2	50	60

Video transcript

Open the prepared Function design spreadsheet.
Select the target. This is a safe custom-function design fixture.
Complete the next action. Enter exactly "DOUBLEVALUE" in A2, "D2" in B2, and "value * 2" in C2.
Apply the change. In E2, enter the standard Sheets formula =D2*2 so the sample output is 14.
The DOUBLEVALUE function design is documented, its sample calculation returns 14, and the existing TAXTOTAL example is preserved.