If Statement Help Please

[lee1101]

Hello

I am trying to do a basic formula on excel for a checklist I am creating. I am not very good with IF statements so hopefully someone can help.

D92 and D96 will only have Yes or No in them. I would like the formula to return this

If D92 and D96 both say Yes, then A2 returns "Status - Filed"
If either D92 or D96 say no then A2 returns "Status - Not Filed"

Thanks very much in advance.

 

[Sin_Chase]

In A2:

=IF(AND(D92="Yes", D96="Yes"), "Status - Filed", "Status - Not Filed")

Basically:

If D92 AND D96 equal Yes then display "Status - Filed" otherwise (Any condition other than both D92/96 being Yes) display "Status - Not filed"

The above only checks for the presence of Yes in both cells.

 

[lee1101]

Marvelous! Thanks very much