Italian Excel formula
=A2*B2/100English Excel formula
=A2*B2/100
Example
If A2 contains 250 and B2 contains 20, the result is 50.
Common errorIf B2 is already formatted as a percentage, use =A2*B2.
How it works
The basic formula is value times percentage divided by 100.
If the cell contains 20%, Excel treats it as 0.20.
Frequently asked questions
How do I calculate 20% of 250?
Use =250*20/100.
Why is the result too small?
Check percentage formatting.