From Dev.to
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. B =ISBLANK(B) =B="" =LEN...