LoveByPDF logo

LoveByPDF
EN

Basics · Percentage formulas

Percentage formulas in Excel - % of, % change, share of total

A percentage is a division formatted as %: part / whole. Increase by 10% is value*(1+10%).

=part/whole   =value*18%   =value*(1+10%)
Write it for my sheet

Examples

Type this in the Formula StudioFormula
“18% of D3”=D3*18%
“D3 as a percentage of E3”=D3/E3
“D3 increased by 10%”=D3*(1+10%)
“D2 out of E2”=D2/E2

People also search for

  • percentage formula in excel
  • how to calculate percentage in excel
  • percentage increase formula in excel
  • percentage change formula excel
  • percentage of total in excel
  • excel formula for gst 18%
  • add 10 percent to a number in excel
  • marks percentage formula in excel
  • percentage formula in excel in hindi

FAQ

How do I calculate percentage change?

Use =(New-Old)/Old, e.g. =(E2-D2)/D2, and format the cell as Percentage. A negative result is a decrease.

How do I add 18% GST to a price?

Use =D2*(1+18%) for the price including GST, or =D2*18% for the GST amount alone.

Can LoveByPDF write this formula for me?

Yes. Open your Excel file in the Excel Agent's Formula Studio, click a cell and type what you need - e.g. "18% of D3" - you get the formula, a preview on your sheet and an explanation, then insert it.

Related formulas