MAXIFS Function in Excel: Largest Value Meeting Conditions
MAXIFS returns the maximum of values where all conditions are met; MINIFS returns the minimum.
Read article →Excel Functions A–Z
Every Excel function explained with syntax, examples, common errors and powerful combinations — from beginner to expert.
TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TEXTJOIN joins a range of text with a delimiter and can ignore empty cells.
Read article →CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT joins text from several cells or whole ranges. It replaces the older CONCATENATE. The & operator does the same for a few cells.
Read article →PDURATION Function in Excel: Years Needed to Reach a Target
PDURATION Function in Excel: Years Needed to Reach a Target
PDURATION returns how many periods an investment needs to grow to a target at a given rate (lump sum, no regular payments).
Read article →RRI Function in Excel: Equivalent Annual Growth Rate (CAGR)
RRI Function in Excel: Equivalent Annual Growth Rate (CAGR)
RRI returns the constant growth rate needed to go from a start value to an end value — i.e. CAGR in one function.
Read article →MIRR Function in Excel: IRR With Realistic Reinvestment
MIRR Function in Excel: IRR With Realistic Reinvestment
MIRR fixes IRR's optimistic assumption that cash is reinvested at the IRR itself, using separate finance and reinvestment rates.
Read article →XNPV Function in Excel: NPV for Cash Flows on Specific Dates
XNPV Function in Excel: NPV for Cash Flows on Specific Dates
XNPV discounts cash flows that happen on irregular dates — more accurate than NPV for real projects.
Read article →DB Function in Excel: Declining-Balance Depreciation
DB Function in Excel: Declining-Balance Depreciation
DB calculates depreciation using a fixed-rate declining balance derived from cost, salvage and life, with an optional first-year month count.
Read article →SLN Function in Excel: Straight-Line Depreciation
SLN Function in Excel: Straight-Line Depreciation
SLN returns equal depreciation for each period of an asset's life.
Read article →EFFECT Function in Excel: Real Annual Rate With Compounding
EFFECT Function in Excel: Real Annual Rate With Compounding
EFFECT converts a nominal annual rate into the effective rate after compounding. NOMINAL does the reverse.
Read article →NPER Function in Excel: How Many Payments Until Paid Off
NPER Function in Excel: How Many Payments Until Paid Off
NPER returns the number of periods needed to repay a loan or reach a savings goal.
Read article →CUMIPMT Function in Excel: Total Interest Over a Range of EMIs
CUMIPMT Function in Excel: Total Interest Over a Range of EMIs
CUMIPMT totals the interest paid between two payment numbers — e.g. for one financial year. CUMPRINC does the same for principal.
Read article →