DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In the IF function example:=IF(A23>=100, “Prize", “No Prize")What would show in the cell after you hit enter if the value in A23 is 89?
|
|
Prize
|
|
|
No Prize
|
|
|
Nothing would show in the cell
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -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-2: -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".
Detailed explanation-3: -=IF(B6=29, ”Try again!”, ”You win!”)
There is 1 question to complete.