Hi Guys

I have the following If formula built

=IF(AND(R15="Yes",S15="Yes",Y15="Yes"),"Yes","No")

but when any of R/s/y15 return a no - the cell is not returning a no it continues to show a Yes

any ideas on what I've done wrong?