HI
Scratching my head on this.
If Q5 has no value, then i would want the resulting cell to produce a blank.
How would the below be changed pls?
=IF(Q5<U5,"GREEN",IF(Q5<V5,"AMBER", "RED"))
Ive tried the below but doesn't give the result i need
=IF(Q5<U5,"GREEN",IF(Q5<V5,"AMBER",IF(Q5<V5, "RED", " "))
Regards
M
Scratching my head on this.
If Q5 has no value, then i would want the resulting cell to produce a blank.
How would the below be changed pls?
=IF(Q5<U5,"GREEN",IF(Q5<V5,"AMBER", "RED"))
Ive tried the below but doesn't give the result i need
=IF(Q5<U5,"GREEN",IF(Q5<V5,"AMBER",IF(Q5<V5, "RED", " "))
Regards
M