The basics
Raise or lower a number by a percent
=A2*(1+B2)How it works in Excel
- 1 stands for the full amount.
- B2 is the percent added on top.
- For a discount, use (1-B2).
- The brackets matter, because Excel multiplies before it adds.
The idea in general
A 20% raise means you end up with 120% of what you started with.
What I assumed
- The amount is in A2 and the percent is in B2.
Check the result on your own data before relying on it.