Excel: percents for discounts, change and goals
Sign up free to unlock this topic
Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.
Try the free sample: The ideal gas law · Have a class or homeroom code? Join here
Key idea: Excel: percents for discounts, change and goals
A percent in a cell is a decimal (15% = 0.15). Price after a discount = price × (1 − discount). Percent change = (new − old) ÷ old. Progress toward a goal = total ÷ goal.
Key words
- × (1 − 15%)
- Takes 15% off.
- % format
- Shows 0.15 as 15%.
🔎 What to look for: Divide by the old value, not the new one.
