Question

29. What would be the result of the given function in
MS-Excel 2010?
= IF(100 < 200, 1/0, "hello")
A. hello
B. 1/0
C. #NULL
D. #DIV/0!​

Answer 1

D. #DIV/0!​ is correct answer

Explanation:

The IF method evaluates a logical expression and return one value if expression evaluates to TRUE otherwise returns false value.

Print "pass" if scores above 70 otherwise "fail"  := IF(A1>70,"Pass","Fail")

Syntax  

=IF (logical_expression, [true_value], [false_value])

The #DIV/0! Error arises when an equation fails to divide by zero or the corresponding value of zero. The #DIV/0, like other mistakes! It's helpful because it shows you something is missing or wrong in the list. You could see #DIV/0! Errors in entering data, but not yet complete. For example, because data is not yet available, a cell in the worksheet is blank.