# How to Step Rounding Percentage

Options
✭✭✭✭
edited 07/24/24

Below is a very basic formula actual/workset a to get the %achieved.

You can see that the two calculations are off one should be 33%, the other 20%

What is the best way to show the actual value, not the rounded value?

Thanks!

Tags:

• ✭✭✭✭
Options

Ah! I figured it out. It was essentially a double-rounding error.

The formula in Workset A column was 22*0.25, now it's =rounddown(22*0.25)

Then when I apply the formula to the %Achieved column (actual/workset A) it's now accurate. Now I know I need to be more conscious about formulas when there are shared components.

Thanks pointing me in the right direction.

• ✭✭✭✭✭
Options

In your sheet toolbar, look for the highlighted icon below.

• ✭✭✭✭
Options

Thanks — I already tried that — it only adds decimal places. It doesn't correct the formula result.

This is the simple formula I'm using: =IFERROR(Actual@row / [%Achieved]4, "--")

• ✭✭✭✭✭
edited 07/25/24
Options

Im assuming that the formula `=IFERROR(Actual@row / [%Achieved]4, "--")` is in column Workset A, and you want to correct %Achieved column.

What is your formula for the %Achieved column to show that it is 36% and 21%?

If formula for %Achieved is what you are looking for, I think should be `=IFERROR(Actual@row / [Workset A]@row, "--")`

...

• ✭✭✭✭
Options

Ah! I figured it out. It was essentially a double-rounding error.

The formula in Workset A column was 22*0.25, now it's =rounddown(22*0.25)

Then when I apply the formula to the %Achieved column (actual/workset A) it's now accurate. Now I know I need to be more conscious about formulas when there are shared components.

Thanks pointing me in the right direction.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!