FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Syntax. Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK")

Detailed explanation-2: -A logical test can be a comparison between two cell references such as A2>B1. Or A logical test can be a comparison between a cell reference and a fixed amount such as C7>= 100. A comparative operator will always return a True or False result.

Detailed explanation-3: -Value If True: The value that is returned if Logical test is TRUE. If omitted, TRUE is returned. Value If False: The value that is returned if Logical test is FALSE. If omitted, FALSE is returned.

Detailed explanation-4: -Top Answer b )Explanation: IN MS Excel, “IF” function is used to check the particular condition. It will return differently depending on the result of the condition was TRUE or FALSE. Thus, option (b) is correct.

Detailed explanation-5: -IF is one of the Logical functions in Microsoft Excel, and there are 3 parts (arguments) to the IF function syntax: logical test: TEST something, such as the value in a cell. value if true: Specify what should happen if the test result is TRUE. value if false: Specify what should happen if the test result is FALSE.