USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which is the correct way to write this function:IF C4 is less than 75, multiply C4 by 10, otherwise, show 0.
|
|
=IF(C4<75, “Multiply 10", “0")
|
|
|
=IF(C4<75, C4x10, 0)
|
|
|
=IF(C4<75, C4*10, 0)
|
|
|
=IF(C4>75, C4*10, 0)
|
Explanation:
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 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 <
There is 1 question to complete.