Information

I don't have actual questions here, the purpose of this page is to familiarize you with the functions.

There are various functions in Excel you can use to determine the type of data stored within a cell. Here are some examples. Most of these functions will return the value "TRUE" if the cell contains the data type you are looking for. The "TRUE/FALSE" value is very useful when used in an "IF" statement.

The "isblank" function will return the "TRUE" value if the reference is to a blank cell. For example, the formula =isblank(A12) will return the value "TRUE" if cell A12 is a blank cell. Otherwise, it will return "FALSE".

The "iserror" function will return the "TRUE" value if the reference is to an error. This could be a cell or a formula. For example, the formula =iserror(1/0) will return the value "TRUE" because anything divided by zero is an error. If cell A12 contains the formula =1/0, then =iserror(A12) will return "TRUE" also.

The "isnumber" function will return the "TRUE" value if the reference is to a number. This could be a cell or a formula. For example, the formula =isnumber(1) will return the value "TRUE" because 1 is a number.

The "istext" function will return the "TRUE" value if the reference is to text. This could be a cell or a formula. For example, the formula =isnumber("1") will return the value "TRUE" because the value between the brackets is text (it is surrounded by quotation marks, therefore Excel treats it as text).