Question: how to create a formula in excel to add percentage?
Answer: 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).