DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Formula
|
|
|
AutoSum
|
|
|
IF Function
|
|
|
NOW()
|
Detailed explanation-1: -Microsoft Excel provides 4 logical functions to work with the logical values. The functions are AND, OR, XOR and NOT. You use these functions when you want to carry out more than one comparison in your formula or test multiple conditions instead of just one.
Detailed explanation-2: -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") =IF(A2=B2, B4-A4, "")
Detailed explanation-3: -For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE. By using the AND function as the logical test argument of the IF function, you can test many different conditions instead of just one.