The ____ function tests a condition and returns one of two values;the function returns the first value if the condition is true and the second value if the condition is false.
A)IIf
B)Pmt
C)IsNull
D)NPV

Question

Quizplus · Accepted Answer

The IIf function is built specifically for testing a condition and returning one of two values. It takes three arguments: the condition to test, the value to return if the condition is true, and the value to return if the condition is false. Pmt calculates the payment for a loan based on constant payments and a constant interest rate. IsNull tests whether a value is null or not. NPV calculates the net present value of an investment based on a series of cash flows.

The ____ Function Tests a Condition and Returns One of Two