In the formula =IF(ISBLANK(A9)," ",VLOOKUP(A9,Products,2,FALSE)), if cell A9 is blank, Excel displays ____.
A) a string of empty characters
B) the word "products"
C) the word "FALSE"
D) the error "#VALUE"

Name: In the formula =IF(ISBLANK(A9)," ",VLOOKUP(A9,Products,2,FALSE)), if cell A9 is blank, Excel displays ____. A) a string of empty characters B) the word "products" C) the word "FALSE" D) the error "#VALUE"
Brand: Quizplus
Rating: 4.9 (32 reviews)

Question

Quizplus · Accepted Answer

When A9 is blank, the IF function returns a space (" "), as specified in the formula.

In the Formula =IF(ISBLANK(A9)," ",VLOOKUP(A9,Products,2,FALSE)), If Cell A9 Is Blank