Precentage out of 2 cells

A Rose

Hi,

Current formula is:

 =[Column A]@row/[Column B]@row

How do I add a precentage at the end I.e. 99% or 100% and not 5.2554...

Thank you!

A Rose

Hi @Paul Newcome,

Thanks for your assistance on this,

What worked best for me was this simple one..

=IFERROR([Column B]@row/[Column A]@row, "")

Then made it to a precentage column from the ribbon.

Thank you!

BullandKhmer

Hi there,

In the tool bar change the formatting of the cell to %

AJ.

A Rose

Hi,

but then the numbers aren't just 2 digits when i change to "%" the numbers are 14.xxxxx

how do I remove that?

Thank you!

Malaina Hudson

Use the increase decimal / decrease decimal button to format the column to your desired number of decimals.

A Rose

When decreasing decimal, 7.88889 becomes 7.89, when turning on precentage it becomes 789%

Any resolution to have both "7.89%"?

Thank you!

Paul Newcome

Try this...

=ROUND([Column A]@row/[Column B]@row, 2) + "%"

A Rose

Hi @Paul Newcome,

Thanks for your assistance on this,

What worked best for me was this simple one..

=IFERROR([Column B]@row/[Column A]@row, "")

Then made it to a precentage column from the ribbon.

Thank you!