IF two different conditions are met

[AnnaV]

How do I enter a formula where two different conditions have to be met?

I have a date in G3 and either "complete" or "incomplete" in H3. I wan
to put a formula in I3 that states if G3 has a date and H3 i
"complete" then return "Yes" otherwise return "No".

Can it be done

 

[Frank Kabel]

Hi
try
=IF(AND(ISNUMBER(G3);H3="complete");"Yes";"No")

 

[AnnaV]

It doesn't seem to be working it says there's an erro

 

[AnnaV]

Nevermind.... it worked

Thanks

 

[Frank Kabel]

Hi
sorry,
was just using my German version. Try:
=IF(AND(ISNUMBER(G3),H3="complete"),"Yes","No")