The IF function is one of the most common functions in Excel and helps you to make reasonable connections between the value and what you expect. So the IF statement could have two results. The first consequence is that if your comparison is valid, the second if your comparison is wrong.

​

How is this working? The IF function can perform a logical test and return a value for a TRUE result and a value for a FALSE result. eg, to pass scores above 70: IF values are greater than 70, to highlight red, otherwise to highlight green. IF nesting functions can test more than one condition. The IF function can be combined with logical functions such as AND and OR.

​

Learn more about the Logical Functions (IF Function) by joining this webinar. This will allow you to check for a specific condition and to modify the data according to a specific condition.