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

Helen Coen

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

Paul Newcome

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"))

Paul Newcome

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"))

Helen Coen

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

Paul Newcome

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"))

Helen Coen

works perfectly, thanks!

Paul Newcome

Happy to help. 👍️