What can I use the IF, AND, or OR Excel 2007 functions for? The IF function is used to apply a test before performing a action. For example, IF a cell equals 89 then display the text B+ as a letter grade. Or without displaying text you can use the IF function to then perform a another function or calculation IF a certain condition is met or a number equals or is greater then say a specified value. The AND function used with the IF function allows you to add additional tests or criteria to meet before performing a true versus false statement. The OR function in conjunction with the IF function defines that either criteria can be meet before executing the true statement the IF function.

Purchase the training video and you can see this in action for yourself!