Help for the formula

[tran1728]

Dear All,

Please i need the formula for colum D Status, it can display Pickcal or In
or Out or Picked.

Colum A Colum B Colum C Colum D
Confirm Date scanin scanout Status

Pickcal
17-03-10 11:38 In
17-03-10 11:38 17-03-10 11:49 Out
17-03-10 11:25 17-03-10 7:29 17-03-10 8:24 Picked
17-03-10 11:20 Picked


Thans so much.
Tran1728

 

[tran1728]

Dear All,

Please i need the formula for colum D Status, it can display Pickcal or In
or Out or Picked.

Colum A Colum B Colum C Colum D
Confirm Date scanin scanout Status
Pickcal
17-03-10 11:38 In
17-03-10 11:38 17-03-10 11:49 Out
17-03-10 11:25 17-03-10 7:29 17-03-10 8:24 Picked
17-03-10 11:20 Picked


Thanks so much.
Tran1728

 

[Fred Smith]

You need to give us the rules. What determines whether it's "Pickcal", "In",
"Out" or "Picked"?

Regards,
Fred

 

[tran1728]

Hi, thanks for your reply,
Pickcal", "In", "Out" or "Picked" , they are words

 

[Fred Smith]

We realize they are words. Under what conditions do you want "Pickcal" in
column D? Under what conditions do you want "In" in column D? Same for "Out"
and "Picked".

Regards,
Fred

 

[tran1728]

Hi Fred,
1. Colum B , C and A are Void , Colum D display "Pickcal"
2. Colum B has the date, C and A are void, D display "In"
3. Colum B and C have the date, C is void, D display " OUt"
4. Colum B, C and A have the date, D display " Picked"
5. Colum B and C are void, A has the date, D display "Picked"

Thanks so much

 

[tran1728]

AMEND

Hi Fred,
1. Colum B , C and A are Void , Colum D display "Pickcal"
2. Colum B has the date, C and A are void, D display "In"
3. Colum B and C have the date, A is void, D display " OUt"
4. Colum B, C and A have the date, D display " Picked"
5. Colum B and C are void, A has the date, D display "Picked"

Thanks so much

 

[Fred Smith]

=IF(AND(A1="",B1="",C1=""),"Pickcal",IF(AND(B1>0,A1="",C1=""),"In",IF(AND(B1>0,C1>0,A1=""),"Out","Picked")))

Regards,
Fred

 

[tran1728]

you are the specialist, superb. Merci beaucoup.
Thanks so much.

 

[Fred Smith]

Pas de quoi,

Fred

you are the specialist, superb. Merci beaucoup.
Thanks so much.