Return Blank if cell is blank IF statement

[mrsushi]

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

 

[Peter_SSs]

Like this?

=IF(Q5="","",IF(Q5<U5,"GREEN",IF(Q5<V5,"AMBER", "RED")))

 

[mrsushi]

Like this?

=IF(Q5="","",IF(Q5<U5,"GREEN",IF(Q5<V5,"AMBER", "RED")))

Hi tried it, but still not producing the blank. For you information, the column Q are times. Its referencing another table so if there is no time pickedup, it will return the value 00:00 in Q5. from here maybe the above formula needs a variation of timevalue?

 

[Peter_SSs]

If Q5 has no value

no time pickedup, it will return the value 00:00 in Q5.

00:00 is not the same as "no value".

Try this instead

=IF(Q5=0,"",IF(Q5<U5,"GREEN",IF(Q5<V5,"AMBER", "RED")))

 

[Rahul1987]

How about?

Return blank cell.xlsx
	N	O	P	Q	R	S
3				3	1	2
4				Amber	Green	Red
5				8	1	0
6	Output
7	Red
Sheet1

Cell Formulas
Range	Formula
N7	N7	=IF(ISNUMBER(Q5),IF(ISNUMBER(R5),IF(ISNUMBER(S5),IF(Q5<S5,"Green",IF(Q5<V5,"Amber","Red"))),""),"")

 

[mrsushi]

00:00 is not the same as "no value".

Try this instead

=IF(Q5=0,"",IF(Q5<U5,"GREEN",IF(Q5<V5,"AMBER", "RED")))

Working now. Thank you very much

Regards
M

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.