Challenge #386: Shed Light on a Bank’s Risky Business

[Awaleczek]

If you end up replacing that empty high value with a number like "999999999999" have a look at this one. It's unlikely that such a value is ever reached but you can never be 100% certain :)

Spoiler

IF [Value] > [Amber Low] and [Value] <= [Amber High]
THEN 'Amber'
ELSEIF [Value] > [Green Low] and ([Value] <= [Green High] OR IsNull([Green High]))
THEN 'Green'
ELSE 'Red'
ENDIF

[ScottLewis]

Pleasantly fiddly and a good reminder to look at the data rather than just reading the instructions.

[tammybrown_tds]

I thought that I was oversimplifying things, but maybe not.

Spoiler

[JamesCharnley]

Spoiler

nice formula

[synergy825]

Spoiler

[Anmol97]

Here's my solution

[nSpire]

Spoiler

[deansrd44]

solution attached 

[LiuZhang]

Spoiler

[karlhansen]

Spoiler

 

I could have reduced most of this to a single Formula tool, but maintenance would be more difficult.