Nested IF Functions in Excel
Wednesday October 1, 2008
Believe it or not some people shy away from using the IF function because of its apparent complexity. In doing so, they are missing out on one of the most useful functions available in spreadsheet programs like Excel.
Using the IF function adds flexibility to a spreadsheet by introducing decision making. What the IF function does is test to see if a certain condition is true or false. If it is true, the function enters one result in a specific cell. If the condition is false, it enters a different result into that cell.
To further increase the flexibility of your spreadsheets, it is possible to Nest or place one IF function inside another.
To find out how to do this, read the article on Nested IF Functions in Excel.
Related Articles
Using the IF function adds flexibility to a spreadsheet by introducing decision making. What the IF function does is test to see if a certain condition is true or false. If it is true, the function enters one result in a specific cell. If the condition is false, it enters a different result into that cell.
To further increase the flexibility of your spreadsheets, it is possible to Nest or place one IF function inside another.
To find out how to do this, read the article on Nested IF Functions in Excel.
Related Articles
No comments yet. Leave a Comment