Category:

Course Description:

We cover a few examples in this tutorial including: 1. Simple IF function (also with greater than or less than checks). 2. IF Formula together with AND logical test to decide outcome if more than one condition is met. 3. Nested IF formula (an IF inside another IF) to check for multiple criteria. 4. IF formula with OR function (to check if “either” condition is met and then decide the outcome). 5. We also take a look at using formulas (other calculations) inside the IF function and finally: 6. How to use symbols as the result of the IF formula Your IF formula isn’t working? One of the main mistakes is the “else” argument. That’s the last argument inside the IF function. Make sure you haven’t forgotten to specify what should happen “if” the condition isn’t met. In case you have more than one condition, here’s the place to add the second “if” statement. An IF formula inside another IF formula is called a nested if function. Course Length: 15:22 minutes Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.