Remember that each “argument”, as Excel calls them, is separated by a comma.
If there was only one condition that needed to be met, such as that the invoice must be paid, then we could use the following formula in cell F2: But OR() will give the result “True” if any of the conditions are met.īy inserting an AND formula or an OR formula into the section of an IF formula where it would normally evaluate one condition, you can effectively evaluate multiple conditions.Īs an example, let’s build a formula that will calculate a 10% commission only if an invoice has been paid and the margin is at least 20%.įirst let’s look at two simple examples that we’ll be able to combine to build the formula we need. AND() will give the result “True” only if all of the conditions (arguments) are met, otherwise the result is “False”. AND and OR are each able to evaluate up to 255 conditions (Excel calls those conditions arguments). What if you need to evaluate multiple conditions? That’s where the AND() function and the OR() function come in. IF is an extremely useful function, but it is limited to evaluating one condition. For example, when evaluating test scores you might want to display “Pass” if the score is 80% or better, but display “Fail” if the score is below 80%. Excel’s IF() function, in case you aren’t familiar with it, allows you to do one thing if a chosen condition is met, but do something else if that condition is not met.
