Microsoft Excel Calculator Formula

Microsoft Excel – In Excel, you can use a variety of formulas to perform calculations. Here are some common examples:

Basic Arithmetic Operations

• Addition: =A1 + B1

• Subtraction: =A1 - B1

• Multiplication: =A1 * B1

• Division: =A1 / B1

SUM

To add up a range of cells: 

=SUM(A1:A10)

AVERAGE

To calculate the average of a range:

=AVERAGE(A1:A10)

MIN and MAX

To find the smallest or largest value in a range:

=MIN(A1:A10)

=MAX(A1:A10)

COUNT and COUNTA

To count numbers or non-empty cells:

=COUNT(A1:A10) ' Counts only numerical values

=COUNTA(A1:A10) ' Counts all non-empty cells

IF Statement

To perform conditional calculations:

=IF(A1 > 10, "Above 10", "10 or less")

VLOOKUP

To search for a value in the first column of a range and return a value in the same row from another column:

=VLOOKUP(A1, B1:D10, 2, FALSE)

In this example, A1 is the value you’re looking up, B1:D10 is the table range, 2 is the column number from which to retrieve the value, and FALSE means an exact match is required.

HLOOKUP

To search for a value in the top row of a range and return a value in the same column from another row:

=HLOOKUP(A1, B1:D10, 2, FALSE)

INDEX and MATCH

An alternative to VLOOKUP that allows more flexibility:

=INDEX(B1:B10, MATCH(A1, A1:A10, 0))

In this example, MATCH finds the position of A1 in the range A1:A10, and INDEX returns the value from the corresponding position in the range B1:B10.

CONCATENATE

To join text from multiple cells:

=CONCATENATE(A1, " ", B1)

Or using the & operator:

=A1 & " " & B1

ROUND

To round a number to a specified number of decimal places:

=ROUND(A1, 2)

PMT

To calculate the payment for a loan based on constant payments and a constant interest rate:

=PMT(rate, nper, pv)

Where rate is the interest rate per period, nper is the total number of periods, and pv is the present value (loan amount).

These formulas can be adjusted based on your specific needs and the structure of your Excel worksheet.