2 If then statements

[Traceelewis71]

I want to create 2 if-then statements and if the 4 cells match it returns a value of Yes, if not then No
what am I doing wrong
=IF(AND(F4=Q4),IF(AND(H4=S4),YES))

Thanks,

 

[Fluff]

How about
=IF(AND(F4=Q4,H4=S4),"YES","NO")

 

[Traceelewis71]

So Simple!!!
It worked Thank you!

 

[Fluff]

Glad to help & thanks for the feedback