Operation with IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions


There are some outputs which are controlled whether they are text, number or the cell is blank.

Here, IF() function provides to control the output and show the results according to given condition.

ISTEXT() controls whether the output is text or not.

ISNUMBER()  controls whether the output is number or not.

 ISBLANK()  controls whether the cell is blank or not.