HI, I'm trying to do an IFS formula to create a Green, Amber Red status using the following scoring:
If score is 90% (GREEN)
If score is 80-89% (AMBER)
If score is 1-79% (RED)
I've used the below sequence, however it recognises the Green and Amber instruction but not the RED, can you help?
=IFS(C314>=90, "GREEN",C314>=80-89,"AMBER",C314>=1-79,"RED")
I've included the attachment.
Thanks
Your Amber section is actually wrong, as is the Red. You need:
=IFS(C314>=90, "GREEN",C314>=80,"AMBER",C314>=1,"RED")
though this doesn't cater for a 0, not sure if that could be a problem?
By way of explanation as to what was wrong initially, when you write this:
C314>=80-89
Excel will subtract 89 from 80 (to get -9) and then compare that to C314. So anything beteween -9 and 90 would be treated as "Amber".
