SheetError (@sheeterror)

ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

ISBLANK(B3) returns FALSE, but B3 looks completely empty. And =IFBLANK(B3,"none") throws #NAME?. Both are expected behavior. Here's what each "empty" test actually checks. Three cells that all look em

10h ago · 2 min readsheeterror.hashnode.dev

VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

You can see the key in the table, and VLOOKUP(..., FALSE) still says #N/A. That's almost never a missing row. Exact match compares values, not what the cell looks like. The two usual culprits are a nu

3d ago · 2 min readsheeterror.hashnode.dev

Fix "Function ADD parameter 2 expects number values" (#VALUE!) in Google Sheets

You type =A2+B2, and instead of a total the cell shows #VALUE!. Hover it and the tooltip says: Function ADD parameter 2 expects number values. But 'pcs' is a text and cannot be coerced to a number.

14d ago · 3 min readsheeterror.hashnode.dev

SheetError

About

Available for

SheetError's blogs

ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

Fix "Function ADD parameter 2 expects number values" (#VALUE!) in Google Sheets

SheetError

About

Available for

SheetError's blogs

ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

Fix "Function ADD parameter 2 expects number values" (#VALUE!) in Google Sheets

SheetError

About

Available for

SheetError's blogs

ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

Fix "Function ADD parameter 2 expects number values" (#VALUE!) in Google Sheets

Search Hashnode

SheetError

About

Available for

SheetError's blogs

ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

Fix "Function ADD parameter 2 expects number values" (#VALUE!) in Google Sheets