FORMULAR

New Contributor

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.

2 Replies

@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

thank you