Question

Question 3: Briefly describe five of the nine IS functions. The options are: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, and ISTEXT.

Answer 1

ISBLANK - WE use ISBLACK function to see if a cell is empty or not empty
e.g = ISBLACK(B1) will return TRUE if B1 is empty,and FALSE if B1 contains text or formulas.
ISBLACK means 'is empty'.

ISNUMBER - We use ISNUMBER function to check if a value is a number or not.
ISNUMBER return TRUE when value is numeric and FALSE when not.
e.g = ISNUMBER(B1) will return TRUE if B1 contains a number or a formula that return a numeric value.

ISTEXT - ISTEXT function will return TRUE when value is text.

e.g = ISTEXT(B1) will return TRUE if B1 contains 'text string' .

ISREF - we use ISREF function to check if value is a reference.
ISREF will return TRUE when value is reference and FALSE if not.

ISNA - we use ISNA function to check if a value is #N/A.
e.g ISNA(B1) will return TRUE if B1 contains #N/A else will return false.