Need correct if() formula

[luckyros]

I want to use IF() condition in the ExampleS.xlsx file i have attached.

The result must be displayed in D column(Eligible Yes/No).

i want that if Days present is greater than or equal to 18 AND NCNS is 0 than the answer must be Yes. But if days present is less than 18 AND/OR NCNS is greater than 0 than answer must be No. If either of the condition is false then also answer must be No.

[yurttas]

Try...

D2;

=IF(AND(B2>=18,C2=0),"Yes","No")

Copy down.

.

[luckyros]

Bingo...Done....Thanks a Ton...