Question EN

How do I calculate a percentage in Excel?

Answer

Multiply the number by the percentage and divide by 100. For example, =A1*15/100 or simply =A1*15% — Excel understands both.

Detailed explanation

Calculating percentages in Excel is one of the most common tasks. Good news: it's easier than you might think.

The Basic Formula

To find a percentage of a number, multiply it by the percentage and divide by 100:

=A1*15/100

Or shorter — Excel understands the percent sign:

=A1*15%

Real-World Examples

20% discount on $5000: =5000*20% → 1000
Sales tax at 8%: =B2*8% or =B2*0.08
15% tip: =C3*15%

What Percentage Is One Number of Another?

The reverse problem — finding what percentage one number is of another:

=A1/B1*100

Or format the cell as "Percentage" and simply use =A1/B1.

14.12.2025 Excel / Google Sheets

Need a custom formula?

Describe your task — AI will generate a working formula in seconds

Generate Formula

Related Questions

How do I round numbers in Excel?

Use the ROUND function: ROUND(number, decimals). For example, =ROUND(3.14159, 2) returns 3.14. For rounding up use ROUNDUP, for down use ROUNDDOWN.

How do I calculate an average in Excel?

The AVERAGE function calculates the arithmetic mean. For example, =AVERAGE(A1:A10) computes the average of a 10-cell range.

How do I raise a number to a power in Excel?

Use the ^ operator or the POWER function. For example, =2^3 or =POWER(2,3) — both return 8 (two cubed).

How do I get the absolute value in Excel?

The ABS function returns the absolute value of a number. For example, =ABS(-15) returns 15, and =ABS(15) also returns 15.

How do I combine text from multiple cells in Excel?

Use the & operator or the CONCATENATE function. For example, =A1&" "&B1 joins cell contents with a space between them.

Great formula!

Sign in to save formulas and get more free requests

Sign in for free