ISBLANK
=IF(ISBLANK(A2),"",B2*C2)Checks whether A2 has never received a value.
PASTE-READY RECIPE
If a Cell Is Blank, Leave the Result Blank in Google Sheets
Keep a formula cell empty until its source cell has data.
QUICK ANSWER
The formula and where it fits.
Keep a formula cell empty until its source cell has data. Use =IF(A2="","",B2*C2), then replace the sample ranges with the columns in your sheet.
The first IF test stops the calculation when A2 is empty.
- Put the source data under one header row.
- Paste the formula into an empty result cell.
- Change the ranges and criteria to match your sheet.
- Check the result against one row you can verify manually.
TRY ITEdit the table.
Edit the table.
Watch the result change.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Price | Qty |
| 2 | |||
| 3 | |||
| 4 |
FORMULA OUTPUT24 · blank · 20Recalculates from the input cells above
VARIATIONS
Use the version that fits your sheet.
Ignore spaces
=IF(LEN(TRIM(A2))=0,"",B2*C2)Treats a cell containing spaces as blank.
Several required cells
=IF(COUNTA(A2:C2)<3,"",B2*C2)Waits until all three inputs are filled.
COMMON ERRORS
When the result looks wrong.
A formula that returns empty text is not ISBLANK
Use A2="" when another formula may return an empty string.
Zero disappears
Test the source cell, not the calculated result.
QUESTIONS
Answers before you paste.
A formula that returns empty text is not ISBLANK
Use A2="" when another formula may return an empty string.
Zero disappears
Test the source cell, not the calculated result.
MAKE IT YOURS
Adjust this formula →Change the ranges, labels or criteria.
Send this recipe to the SheetSteps assistant and describe how your columns are arranged.