Hey Everyone
I haven't used Excel for quite sometime and I am struggling with an IF statement.
I have a dropdown with % values from 0, 5, 10, 15, 20% up until 100, the percentage dropdown is in cell E6.
In cell G6 I want to look at cell E6, if the value is 79% or Less I want the word Red to appear, if its 80 I want the word Green to appear and if its 81 or higher I want Green+ to appear.
I haven't used Excel for quite sometime and I am struggling with an IF statement.
I have a dropdown with % values from 0, 5, 10, 15, 20% up until 100, the percentage dropdown is in cell E6.
In cell G6 I want to look at cell E6, if the value is 79% or Less I want the word Red to appear, if its 80 I want the word Green to appear and if its 81 or higher I want Green+ to appear.