Condition Formula with multiple IFs and Ands

[AudyAnalyst]

Hello,

I am trying to get my formula to look at 2 conditions and respond with 3 options. If both conditions are True then "Sucess", if the Only the First condition (the date range)is met "Yes", If neither are met "No".
The First condition is a date range: =IF(AND($E$1>=C2,$E$1<=D2),"Yes","No")
The second condition is if the Status is "Completed" : =IF(B3="Completed","Sucess","No")
When I try to combine the IFs error message "#VALUE!". =IF(AND($E$1>=C4,$E$1<=D4),"Yes","No"),IF(B4="Completed","Sucess","No")
Any Advice?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(AND($E$1>=C4,$E$1<=D4,B4="Completed"),"Success",IF(AND($E$1>=C4,$E$1<=D4),"Yes","No"))

 

[AudyAnalyst]

Thank you !

 

[Fluff]

You're welcome & thanks for the feedback.