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(C20;"Yes")) But it does
not work.

Please help me.
--
** Fool on the hill **

Try =IF(B2<1,"",IF(C20,"Yes","No"))
But why use a validation when you are using a formula?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jaydubs" wrote in message
...
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(C20;"Yes")) But it does
not work.

Please help me.
--
** Fool on the hill **

Thanks Bernard,
Yes indeed,... excel(lent) point !! (about the validation)
Merci !!
--
** Fool on the hill **


"Bernard Liengme" wrote:

Try =IF(B2<1,"",IF(C20,"Yes","No"))
But why use a validation when you are using a formula?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jaydubs" wrote in message
...
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(C20;"Yes")) But it does
not work.

Please help me.
--
** Fool on the hill **