May 20, 2022
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?
I've included the attachment.
November 1, 2018
Your Amber section is actually wrong, as is the Red. You need:
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:
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".