Help with formula - if cell is blank not to perform calclation

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

Try

=IF(COUNTIF(A5:E5,""),"Awaiting Completion",IF(COUNTIF(A5:E5,"yes")=5,"Approved","Declined"))

Thank you so very much and for being so fast to respond.

Or try:

=IF(COUNTIF(A5:E5,"No"),"Declined",IF(COUNTIF(A5:E5,"yes")=5,"Approved","Awaiting Completion"))

Thank you very much.
Sue