# Please could I have a suggestion for a formula for the below

✭✭✭

If budget forecast is between 90-100% green, if budget forecast is greater than 100% but less than 103% OR between 80-90% yellow otherwise red

• ✭✭✭✭✭✭

My apologies. Wrong function.

=IF(AND([Budget Forecast]@row>= 0.90, [Budget Forecast]@row<= 1), "Green", IF(AND([Budget Forecast]@row>= 0.80, [Budget Forecast]@row<= 1.03), "Yellow", "Red"))

• ✭✭✭✭✭✭

Try something like this:

=IF(AND([Budget Forecast]@row>= 0.90, [Budget Forecast]@row<= 1), "Green", IF(OR([Budget Forecast]@row>= 0.80, [Budget Forecast]@row<= 1.03), "Yellow", "Red"))

• ✭✭✭

Hi Paul

Thanks, the first bit works (i.e. 90-100% goes green, anything else goes yellow, I don't get a red symbol regardless of the number

• ✭✭✭✭✭✭

My apologies. Wrong function.

=IF(AND([Budget Forecast]@row>= 0.90, [Budget Forecast]@row<= 1), "Green", IF(AND([Budget Forecast]@row>= 0.80, [Budget Forecast]@row<= 1.03), "Yellow", "Red"))

• ✭✭✭

works perfectly, thanks!

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!