# How to Use Locate Maximum Value In Excel

This example teaches you how to find the cell address of the maximum value in a column.

This example teaches you how to find the cell address of the maximum value in a column.

This example teaches you how to convert a text string to lower, upper or proper case in Excel.

Use MAXIFS and MINIFS in Excel 2016 or later to find the maximum and minimum value based on one criteria or multiple criteria.

This example illustrates three functions to round numbers to a multiple of x in Excel.

The IF function is one of the most used functions in Excel.

Use the IRR function in Excel to calculate a project’s internal rate of return.

When you copy a formula, Excel automatically adjusts the cell references for each new cell the formula is copied to.

This example shows you how to create an array formula that counts the number of errors in a range.

This example shows you how to create an array formula that counts unique values.

Counting with Or criteria in Excel can be tricky. This article shows several easy to follow examples.

An external reference in Excel is a reference to a cell or range of cells in another workbook.

An easy formula that returns the day of the year for a given date.

To calculate the number of days until your birthday in Excel, execute the following steps.

This example illustrates the EVEN and the ODD function in Excel.