Excel Tips: Calculation & Formulas > Formula Application

Addition & Subtract

How to add 1 to a specified cell if cell contains certain text in Excel?

How to add values to multiple cells in Excel?

How to add/sum two numbers then multiply in one formula in Excel?

How to automatically increase letter by one to get the next letter in Excel?

How to calculate if a cell greater than a specific number then subtract in Excel?

How to double click a cell and add 1 to that cell value in Excel?

How to increase or decrease cell number/value by percentage in Excel?

How to subtract a number from a range of cells in excel?

Multiply & Divide

How to divide a range of cells by a number in Excel?

How to divide one column by another column in Excel?

How to divide time by a number (distance) in Excel?

How to mass multiply or divide all values in a column by a number in Excel?

How to mass multiply or divide all values in a column by a number in Excel?

How to multiply a range of cells by same number in Excel?

Calculate Percentages

How to calculate item percentage of total in Excel?

How to calculate percentage change or difference between two numbers in Excel?

How to calculate percentage of total in Excel?

How to calculate the percentage of year or month passed in Excel?

How to calculate the percentage of yes and no from a list in Excel?

Others

Calculate Interest

How to calculate compound interest in Excel?

How to calculate total interest paid on a loan in Excel?

Calculate Payment

How to calculate monthly mortgage payment in Excel?

How to quickly calculate the overtime and payment in Excel?

Calculate Tax

How to calculate income tax in Excel?

How to calculate sales tax in Excel?

Calculate Price

How to calculate bond price in Excel?

How to calculate discount rate or price in Excel?

How to calculate original price from percentage discount in Excel?

Others

How to calculate annual leave in Excel?

How to calculate letter grade in Excel?

How to calculate Make-or-Buy decisions in Excel?

How to calculate rate of return on a share of stock in Excel?

How to calculate the correlation coefficient between two variables in Excel?

How to do exponential calculation to a range of cells in Excel?