IFS with text

[VJarvis]

Hello,
I wonder if anyone can help. I'm trying to write a formula that looks across three values in separate sheets (within one document) to return a value of 'Yes' if all three cells also say 'Yes.' I've tried various IFS and IF AND without any luck and tried to write something along the lines of this which isn't working:
=if(and(PSE!AG3="Yes",CL!AL3="Yes",PD!AL3="Yes",'Yes','No'))
Any help gratefully received!

 

[Fluff]

You have one of the brackets in the wrong place & the wrong quotes on the return value, it should be

 =if(and(PSE!AG3="Yes",CL!AL3="Yes",PD!AL3="Yes"),"Yes","No")

 

[VJarvis]

Works perfectly. Thanks so much for your help!

 

[Fluff]

You're welcome & thanks for the feedback.