Hi,

Can anyone help me? I have a table which approves or declines a request once 5 managers have agreed or not agreed.
If one manager disagrees the event is declined.


Yes Yes Yes Yes No Declined
Yes Yes Yes Yes Yes Approved
Yes Yes Yes Yes Yes Approved
Yes No No Yes Yes Declined
Yes Yes Declined

My coding is working well apart from where there are blank cells:
=IF(AND(A3="Yes",B3="Yes",C3="Yes",E3="Yes"),"Approved", "Declined")

If there are blank cells how can the repsonse be delayed until all 5 managers have responded?

Thank you for any advice.

Sue