Forum Discussion

Muawii's avatar
Muawii
Copper Contributor
Oct 03, 2022

FORMULAR

Please how do I write a formular on excel to convert my previous column into a percentage to an adjacent column.

such that B4 as 8 can automatically be 80% as C4.

  • Muawii 

    Converting 8 to 80% is unusual, but if you really want that, enter the following formula in C4, and format C4 as a percentage:

     

    =B4/10

     

    But if you want to convert 8 to 8%, use

     

    =B4/100

Resources