Hightlighting when a figure is greater than another

[graemeal]

I am having a problem working out a formula

IF A2 is less than 1000 and U2 is greater than 2 times V2 then a yes in column W, IF not then leave column W blank

This my attempt that does not work

=IF(A2<1000,U2>(V2*2),"YES",0)

Preferably I would like one that says IF A2 is less than 1000, U2 is 2 times greater than V2 or 2 times less than V2 then a "yes" in column W. if not leave blank

Thanks

 

[VoG]

Try

=IF(AND(A2 < 1000,U2>V2*2),"YES",0)

 

[graemeal]

Thanks works like a dream (as usual)

How do I replace the 0 with just a blank cell.

And can I include "if 2 times less as well as 2 times greater" in the same formula

If not I can just have 2 seperate formulas so no dramas.

Thanks

 

[VoG]

Maybe

=IF(AND(A2 < 1000,OR(U2>V2*2,U2 < V2/2)),"YES","") <v2 2)),="" yes="" ,="" )=""></v2>

 

[graemeal]

Fantastic again. Works like a dream

Thank you kindly