USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=IF(B7>=50, “Bonus", “No Bonus")
|
|
|
IF(B7>=50, “Bonus", “No Bonus")
|
|
|
=IF(B7>50, “Bonus", “No Bonus")
|
|
|
=IF(B7=50, “Bonus", “No Bonus")
|
Detailed explanation-1: -=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-2: -That means, it can be written as if () or . We 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.
Detailed explanation-3: -Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. You can find all of Excel’s functions on the Formulas tab on the Ribbon: Excel function syntax.