DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=IF(C4<75, “Multiply 10", “0")
|
|
|
=IF(C4<75, C4x10, 0)
|
|
|
=IF(C4<75, C4*10, 0)
|
|
|
=IF(C4>75, C4*10, 0)
|
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: -=IF(logical test, value if true, value if false) The function uses the following arguments: Logical test (required argument) – This is the condition to be tested and evaluated as either TRUE or FALSE.
Detailed explanation-3: -The IF function is a premade function in Excel, which returns values based on a true or false condition. The condition is referred to as logical test, which can check things like: If a number is greater than another number > If a number is smaller than another number <
Detailed explanation-4: -Click on “Insert Function” and select the IF function. Our goal here is to have the function display “Yes” if the result is greater than ten, and “No” otherwise. The logical test will tell us whether the function should display “Yes” or “No". If it is true, the function will display “Yes".