RYG Balls on Simple Formula

John Littler

Hi...simply I want to show a red ball if my value is less than 1, green if it is greater than 5 and yellow if between? I'm missing something?

=IF([Operations Metric]1 < 1, "Red", IF([Operations Metric]1 > 5, "Green", IF([Operations Metric]1, "Yellow")))

Paul Newcome

Try this...

=IF([Operations Metric]1 < 1, "Red", IF([Operations Metric]1 > 5, "Green", "Yellow"))

Paul Newcome

Try this...

=IF([Operations Metric]1 < 1, "Red", IF([Operations Metric]1 > 5, "Green", "Yellow"))

John Littler

Great...thx Paul, too many arguments I guess!

Paul Newcome

Happy to help. 👍️

The problem actually wasn't too many arguments. It was your last argument for "Yellow". You didn't have an actual argument. Just a cell reference.

IF([Operations Metric]1, "Yellow")

Since you already had high and low ends ends established, you can just use "Yellow" as the default for anything that doesn't fall under the previous two.