If you understand the logical functions clearly in Excel, they can prove to be very helpful in the long run. Through this article learn to use the 3 main logical functions:
The IF function evaluates a particular condition in Excel. It returns one value if the condition is true and another value, if the condition is False.
IF(logical_test, [value_if_true], [value_if_false]) wherein
• logical_test: Any value or expression that can be evaluated to TRUE or FALSE.
• value_if_true: The value that you want to be returned if the logical_test argument evaluates to TRUE.
• value_if_false: The value that you want to be returned if the logical_test argument evaluates to FALSE.
In the example below, we want to know if a student has passed a particular subject, so we shall use the IF function. Since the passing marks is 35 and above our logical_test is B2>=35 and our values are True and False. Make sure you insert your commas properly in order to avoid errors.
When you press enter and drag the fill handle, you shall get your desired results.
AND function is used when you want to check more than 1 condition. The AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false.
AND(logical1, [logical2], ...) wherein
• logical1: The first condition that you want to test that can evaluate to either TRUE or FALSE.
• logical2, ... : Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.
In the example below, we want to know if the student has passed in both the subjects or no so we shall find this out by using AND function. Again the passing marks is 35 so our logical1 is B2>=35 and logical2 is C2>=35.
When you press enter and drag the fill handle, you shall receive your results as True and False wherein True means Pass and False means Fail.
What if you want Pass and Fail instead of True and False??? Well that is where our 3rd function comes in, that is using IF function with AND function. In the same example as above, we shall combine the IF and AND function. Refer the image below and you shall see that we have started off with an IF statement and then incorporated the AND function in it. Using your brackets and commas properly is a must over here.
When you press enter and drag the fill handle, you will notice that the data has been filled as Pass and Fail instead of True and False.
We hope that this article was useful to you. If you have any doubts or suggestions then mention it in our comments box and we shall get back to you as early as possible.
Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc
CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.
Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to firstname.lastname@example.org and we will rectify it.
2015 © Edupristine. ALL Rights Reserved.