DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
If(comparison, true value, false value)
|
|
|
If(compare, false, true)
|
|
|
If(true value, comparison, false value)
|
|
|
If(false value, comparison, true value)
|
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: -The FALSE function in Excel is equivalent to the number 0.
Detailed explanation-3: -To display the word TRUE, use the logical value TRUE for this argument. Value if true can be another formula.
Detailed explanation-4: -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.