Meeting attendance overall quoracy

[MarkExcel1]

Hi

I have a meeting I would like to ensure has all the required specialties in attendance to ensure the meeting is quorate to make decisions.

So for example the meeting must have 2 surgeons, 1 nurse & 1 radiologist in attendance to be quorate (able to function).

To check if each specialty is quorate I use the following formula eg. surgeon formula =IF(D4+E4+F4>=2,"Yes","No")

Can I please check if is there a formula I can use to return "Yes" or "No" in the overall quorate column which returns Yes when all specialties are represented and No if one or more specialties is not quorate.

So for example the meeting on 03/01/2024 is overall quorate as all 3 specialties are present but 01/01/2024 is not because only one specialty is fully quorate.

Any help is much appreciated

Mark

 

[SanjayGMusafir]

Try and revert

=IF(And(G4="Yes",K4="Yes",O4="Yes"),"Yes","No")

 

[MarkExcel1]

Try and revert

=IF(And(G4="Yes",K4="Yes",O4="Yes"),"Yes","No")

Thanks very much Sanjay, works perfect!

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.