No formula is needed. The cells can be formatted to display in percent.

If you want the numerical value of a percentage without the "%" symbol, you can multiply by 100.

If you want the numerical value of a percentage without the "%" symbol, you can multiply by 100.

__Example__0.05 = 5% To make .05 display as 5, multiply it by 100. .05*100 = 5 If the value .05 is in cell A1, then type the formula**=A1*100**in the cell where you want the number 5 displayed. If you want the value .05 in cell A1 to display as 5%, format cell A1 to display as percentage.