Logical function in excel provides to apply conditions most commonly used functions we can say
| Above example demonstrates applying logic to get the Grade for each students securing marks as per condition passed through the IF nested functions. The IF Function is used with multiple conditions also known as Nested Function. Condition 1 - IF percentages of student is > = 85% then Mark grade as "A+", if not then check for percentage > = 80% if condition satisfies then Mark grade as "A", if both conditions are not satisfied then look for other conditions as mark grade. Now let us use two functions AND & IF to match the table values with two AND conditions and one IF Condition.  In above example we want to check the eligibility of student for award. Conditions are IF student secures Highest marks in any of the subject and secures percentage students is awarded by $1000, $750 & $500 respectively. Let us now elaborate the function and formula used to identify the students =IF(AND(C2>=85,D2>=85%),"$1000",IF(AND(C2>=80,D2>=80%),"$750", IF(AND(C2>=75,D2>=75%),"$500","Not Eligible"))) IF(AND(HighestMarks, Percentage is >= 85), "$1000" else look for other option IF(AND(Mks & % >=80), "$750" else check for last option that is Mks&% >= 75, award is $500 Simple technique to use such logical functions is to frame the conditions step by step and then convert into formulas. |
No comments:
Post a Comment