Excel Formula for Percent

The formula for converting percent to fraction uses the symbol %. To convert 20% to fraction the formula is as under:

=20%

If you enter 20 in cell A99, you can write formula for conversion to fraction by doing the following:

Enter 2o in cell A99. In cell B99 enter “=”. Click on cell A99. Enter”%”. Press Enter key. The answer 0.2 is given in cell B99.

Previous

TOC

Next