Hi

I hope someone can point me in the right direction.

I want a single cell to populate with "Yes" using data from other cells but I cant get it to work.

What I am hoping in one cell is a YES if:

R5+R6=12 then show YES
&
R8=4 then show YES

If no data is present in R5,R6,R8 or they show as 0 then leave blank

Any help would be gratefully received
Thank you