# Percentage in a formula

Options
✭✭✭✭

Hi,

Happy New Year!

I got stuck with what I thought was a simple formula and I'm hoping you can help me.

We have three different thresholds that I need to use to change the RYG balls:

Above 3% - Red

Between 0 and 3% - Yellow

Below 0% - Green

My formula looks as below:

=IF(ISBLANK(Slippage@row), "", IF(Slippage@row > 0.3, "Red", IF(Slippage@row >= 0, "Yellow", IF(Slippage@row < 0, "Green"))))

It does not work with "Red" at all. I only see yellow and green balls.

• ✭✭✭✭
Options

3% is .03. Try changing your formula to

=IF(ISBLANK(Slippage@row), "", IF(Slippage@row > 0.03, "Red", IF(Slippage@row >= 0, "Yellow", IF(Slippage@row < 0, "Green"))))

Cheers,

John

• ✭✭✭✭
Options

3% is .03. Try changing your formula to

=IF(ISBLANK(Slippage@row), "", IF(Slippage@row > 0.03, "Red", IF(Slippage@row >= 0, "Yellow", IF(Slippage@row < 0, "Green"))))

Cheers,

John

• ✭✭✭✭
Options

Thank you, it worked!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!