Excel IS Functions - Microsoft Excel IS Functions Tutorial
Microsoft Excel IS Functions Tutorial
Microsoft Excel IS Functions Tutorial
What are the Microsoft Excel IS Functions?
The IS functions are a set of computer programs that you run from a worksheet cell formula. Their job is to return a TRUE or FALSE value based upon a condition they evaluate. These functions are basically your worksheet cell value and worksheet formula error testers in logic. Here is a list of the IS functions and what they do:
The IS functions can be used alone in a worksheet formula as a flagging device when processing data on a worksheet. For example, say you have rows of data on a worksheet and you wanted to know if any of those rows had a number in a particular column. You could use the ISNUMBER function to evaluate that case and return TRUE/FALSE. You could then use Excel's AutoFilter to filter on the TRUE/FALSE values returned. The IS worksheet functions are also extremely useful when developing error traps on your worksheet thus preventing your worksheet formulas from generating errors a user can see. They are also useful when designing dashboards especially interpreting what a user has typed in a cell so a formula can adjust to the input. They are very commonly used as a nested function to the first argument of the IF function especially in the cases of error protection and user value interpretation (what the user types in a cell). The AND and OR functions also heavily use these functions as nested functions in their argument list. A complement to these functions is also the Excel Data Validation feature which also helps protect against the user typing the wrong values on a worksheet. Remember, locking down what the user can type is always more effective then trying to have a formula figure out what they typed. You run the IS worksheet functions by typing their names in a formula then followed by the information they are suppose to analyze.
How Do You Type the IS Worksheet Functions in a Formula?
Whenever you type a formula in a worksheet cell, this is called syntax or grammar. The general syntax of the IS functions are like this when you type them in a worksheet cell:
Where value is called the function argument list. Remember, you are running a computer program at this point so the program needs information to operate and that is why there is an argument list. When you see an argument list and you see square brackets [ ] around the argument name, this means the argument is optional and you do not have to include it when typing unless you need it. So for the syntax above, all IS functions take one argument when typing them in a worksheet cell formula. What argument values can be used are discussed above and below this paragraph. Remember functions expect certain things in their argument lists, if you do not put the correct information in the list they will generate an error when run.
How Do You Run the IS Functions?
Since the IS functions are computer programs, they run when you press Enter to enter the formula that contains them. If any of the arguments are wrong, the function will return an error.
What Do I Type for an IS Function Argument?
When typing the IS function in a worksheet cell formula, you need to replace the value argument. Some typical arguments you can use are:
* It is possible to name a cell or group of cells on a worksheet and use that name in place of a range reference or cell reference. Consult Excel help on how to name a cell.
Additional IS Function Examples
The worksheet seen below contains some typical worksheet formulas that run the IS worksheet function. Pay close attention to the argument list and the syntax used to write the formula.
Things to Know About the IS Functions
|Beginning Excel Training for Business Professionals||Intermediate Excel Training for Business Professionals||Advanced Excel Training for Business Professionals||Beginning Excel VBA Training for Business Professionals||Intermediate Excel VBA Training for Business Professionals||Advanced Excel VBA Training for Business Professionals||Advanced Excel Training for Engineers / Scientists||Beginning Excel VBA Training for Engineers / Scientists||Intermediate Excel VBA Training for Engineers / Scientists||Advanced Excel VBA Training for Engineers / Scientists||Microsoft Excel Dashboards Training|
Copyright © 2002-2017
EMAGENIT All Rights Reserved