Conditions with IF statement

[Guest]

Dear Excel(lent) users,

I am processing the following:

When a certain incident is logged, I want to know how many times it 'hops'
(no reason to go into details what bounces means).
I have the following columns:
Column A Date of entry
Column B Date of closure
Column C Date how many times it hops
Column D Yes/No validation field to indicated it hopped

If an incident hops I have to enter the number of hops. Now In Column D, I
want the spreadsheet to automatically fill in Yes or No. The condition is
that B should be filled and C should be 0. If that is the case D should have
no and if C is higher than 0 yes should be filled. If B is not filled,
nothing should be done.

Please be aware that I have entered a validation list on Column D, so that
whenever you press on a field in D, you get to choose either yes or no.

I came up with this: =IF(AND(B2<>"";C2=0);"No";IF(C2>0;"Yes")) But it does
not work.

Please help me.

 

[Bernard Liengme]

Try =IF(B2<1,"",IF(C2>0,"Yes","No"))
But why use a validation when you are using a formula?
best wishes

 

[Guest]

Thanks Bernard,
Yes indeed,... excel(lent) point !! (about the validation)
Merci !!