Combining IF AND formulas

[acct123]

Hi hoping someone can help please

i need to combine to two following formulas and I'm struggling

=IF(AND(D3="yes",NOT(H3="#")),IF(Q3=0,IF(R3<>0,"Chk App/VO's","Complete"),"Chk Inv & VO"),IF(D3="ret","Retn's",""))

=IF(AND(Q3=0,R3=0,X3=0,Y3=0,AG3=0,AH3=0),"Complete","")


any ideas??

[NBVC]

Perhaps?

=IF(AND(Q3=0,R3=0,X3=0,Y3=0,AG3=0,AH3=0),"Complete",IF(AND(D3="yes",H3<>"#"),IF(Q3=0,IF(R3<>0,"Chk App/VO's","Complete"),"Chk Inv & VO"),IF(D3="ret","Retn's","")))

[acct123]

Thankyou NBVC, no error coming up now but doesnt seem to work properly with the criteria?

[NBVC]

Where has it gone wrong? It is first checking AND(Q3=0,R3=0,X3=0,Y3=0,AG3=0,AH3=0) then the rest...