How to Calculate in Excel Sheet?

Select the cell where you want the result

Type the formula starting with =

Use cell references instead of typing numbers directly when possible

Press Enter to calculate the result

Use + for addition

Use – for subtraction

Use * for multiplication

Use / for division

Use ^ for exponentiation

Use SUM for adding a range of cells

Use AVERAGE for finding the mean of values

Use MIN for the smallest value

Use MAX for the largest value

Use COUNT for counting numeric cells

Use IF for conditional calculations

Copy formulas by dragging the fill handle

Check cell references if the result is incorrect

Use parentheses to control calculation order

Suggested for You

Trending Today