Which function should be used to display a value based on a comparison? a. average b. if c. count d. min

B. IF

Explanation:

The IF function  should be used. It is used to display a value based on a set condition which may be the comparison of a value with another.

Usually there are 2 or more conditions that are set when the IF function is used. The system understands it as "if the first condition is true, then return a value otherwise return something else". If example the function "=IF(E3 = 4, 4,5). This will return 4 if the number in cell E3 is 4 otherwise, it will return 5 where the number in cell E3 is not 4.

Therefore, the right answer is B. IF