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.

Zero2Hero — Zéro2Héros