Task 1 of 3
In D2:D5, calculate the discount amount in dollars: price × discount percentage.
Lesson theory
The math operators are + - * / and ^ (power).
The order is the one you learned at school: powers first, then multiplication and division, then addition and subtraction. Parentheses change the order.
=2+3*4 gives 14, but =(2+3)*4 gives 20Percentages in Excel are ordinary fractions: 20% is 0.2. So a 20% discount on a price is =B2*C2,
and the discounted price is =B2*(1-C2) or =B2-D2.
Percentage change: =(New-Old)/Old, then apply the % format on the toolbar.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page