# Precentage out of 2 cells

Options
✭✭✭✭✭

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!

• ✭✭✭✭✭
Options

Thanks for your assistance on this,

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

Then made it to a precentage column from the ribbon.

Thank you!

• ✭✭✭✭✭
Options

Hi there,

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

AJ.

• ✭✭✭✭✭
Options

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!

• ✭✭✭✭✭
Options

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

• ✭✭✭✭✭
Options

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

Any resolution to have both "7.89%"?

Thank you!

• ✭✭✭✭✭✭
Options

Try this...

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

• ✭✭✭✭✭
Options

Thanks for your assistance on this,

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