# How to decrease decimal places in a percentage?

Options
✭✭✭✭✭

Hi,

How do I decrease the decimal places in the String Column to just read 230%🔺? My work is below.

Thank You

• ✭✭✭
Options

You should use the ROUND function. You have two options:

1. Wrap your % formula with a =ROUND(([YTD FEES 2021]@row - [YTD FEES 2020]@row)/[YTD FEES 2020]@row, 0)
2. Wrap a ROUND around each of your calculations in the string =IF([%]@row <0, ROUND([%]@row*100,0) + "% up arrow", IF([%]@row <0, ROUND([%]@row*100,0) + "% down arrow".... etc...

• ✭✭✭
Options

You should use the ROUND function. You have two options:

1. Wrap your % formula with a =ROUND(([YTD FEES 2021]@row - [YTD FEES 2020]@row)/[YTD FEES 2020]@row, 0)
2. Wrap a ROUND around each of your calculations in the string =IF([%]@row <0, ROUND([%]@row*100,0) + "% up arrow", IF([%]@row <0, ROUND([%]@row*100,0) + "% down arrow".... etc...
• ✭✭✭✭✭
Options

Great. Thank you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!