Microsoft Excel Basic Syntax:
INTRO BONUS CLASS SYNTAX EXPLAIN SUM AVERAGE MAX MIN IF SUMIF AVERAGEIF COUNT | COUNTA | COUNTBLANK COUNTIF Excel ShortCut Keys
Excel: IF Syntax | Logically Excel Ko SEEKHEN In a Very Effective Way
PART 1:
PART 2:
IF() Syntax
Download: PDF Notes Excel File
THE IF function can perform a logical test and return one value from a TRUE result, and another for a FALSE result. for example, to “pass” scores above 70: =IF(A1>70,“Pass”,“Fail”).
Syntax:
=IF(logical_test,[value_if_true],[value_if_false])
=IF(condition,[condition_if_true],[condition_if_false])
Parameter:
• logical_test - a value or logical expression that can be evaluated as TRUE or FALSE
• [value_if_true] - (Optional) the value to return when logical_test evaluates to TRUE
• [value_if_false] - (Optional) the value to return when logical_test evaluates to FALSE
Example 1:
=IF(C2>35,"PASS","FAIL")
Output: Pass
Example 2:
=IF(C2>32,"PASS","FAIL")
Output: FAIL
Example 3:
