Apply a discount
Write the price after a 10% discount next to each price in column B.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Sale price” in C1
- Discounted price in C2:C1000
- Show C2:C1000 as currency
Use it in MacroRoni: open the Starter gallery, search for "Apply a discount", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More calculations macros
CalculationsAdd a totals rowAdd a bold total under column B and show it as currency.Changes data · backup onCalculationsRunning totalAdd a running total of column B in column C.Changes data · backup onCalculationsCount and total one categoryCount the rows where column A says Sales and add up their amounts from column B.Changes data · backup on