How do I calculate 15% of a number in Excel?
Multiply an entire column of numbers by a percentage
Enter the numbers you want to multiply by 15% into a column. In an empty cell, enter the percentage of 15% (or 0.15), and then copy that number by pressing Ctrl-C. Select the range of cells A1:A5 (by dragging down the column). Also, What is discount formula?
The formula to calculate the discount rate is: Discount % = (Discount/List Price) × 100.
[Read More]