The series of values for the XNPV function must contain at least one positive and one negative value.

Question

Quizplus · Accepted Answer

The XNPV function calculates the net present value of a series of cash flows at specific dates. The function requires at least one negative cash flow (outflow) and one positive cash flow (inflow) in order to calculate the net present value. Without both types of cash flows, the function would return an error. Therefore, the statement is true.

The Series of Values for the XNPV Function Must Contain