Click an empty cell. Type "=PRODUCT(50%)." Replace "50%" with the percentage by which you want to multiply your column. Press "Enter" to finish entering the percentage in the cell.

Open Microsoft Excel. Enter the percentage you wish to add in cell B1 and include the percent sign, which automatically formats the number as a percentage.

Excel percentage formulas can help with many everyday applications. We'll walk through several examples, ... To check your answer, just add the two numbers together, or multiply $45.87 by 9%.