FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which function checks to see whether the result is something like #N/A (not available) and can return something else instead?
A
AND
B
OR
C
NOT
D
IFERROR
Explanation: 

Detailed explanation-1: -IF function in Excel is best suited for situations where you check whether a condition is TRUE or FALSE. If it’s TRUE, the function returns a specified value/reference, and if not then it returns another specified value/reference.

Detailed explanation-2: -The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.

Detailed explanation-3: -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-4: -IF Formula The IF() function checks a given condition and returns a particular value if it is TRUE. It will return another value if the condition is FALSE. In the below example, we want to check if the value in cell A2 is greater than 5.

There is 1 question to complete.
Previous
Next