Tags » Excel

AVERAGEIF and AVERAGEIFS

These functions calculates the average value of the table with the given criteria. With AVERAGEIFS you could add multiple criteria.

= AVERAGEIF (criteria_range, criteria, average_range) 10 more words

Excel

XIRR Function

It returns the internal rate of return (IRR) for a schedule of cash flows that is not necessarily periodic.

= XIRR ( value, date, guess ) 41 more words

Excel

XNPV Function

This function calculates the net present value (NPV) of an investment with a discount rate and cash flow.

= XNPV (rate, value, date)

rate - discount rate… 28 more words
Excel

CHOOSE Function

It returns a value from the range with given criteria.

= CHOOSE ( index number, value1, value2, … )

The index number would be between a and 254.

Excel

OFFSET Function

= OFFSET ( reference, rows, cols, height, width )

This function is one of the lookup functions in Excel. It returns specified number of rows and columns from the range you put. 93 more words

Excel