| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help for the formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help for the formula
"tran1728" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help for the formula
You need to give us the rules. What determines whether it's "Pickcal", "In",
"Out" or "Picked"? Regards, Fred "tran1728" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help for the formula
Hi, thanks for your reply,
Pickcal", "In", "Out" or "Picked" , they are words "Fred Smith" wrote: You need to give us the rules. What determines whether it's "Pickcal", "In", "Out" or "Picked"? Regards, Fred "tran1728" wrote in message ... 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 . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help for the formula
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" wrote in message ... Hi, thanks for your reply, Pickcal", "In", "Out" or "Picked" , they are words "Fred Smith" wrote: You need to give us the rules. What determines whether it's "Pickcal", "In", "Out" or "Picked"? Regards, Fred "tran1728" wrote in message ... 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 . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help for the formula
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 "Fred Smith" wrote: 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" wrote in message ... Hi, thanks for your reply, Pickcal", "In", "Out" or "Picked" , they are words "Fred Smith" wrote: You need to give us the rules. What determines whether it's "Pickcal", "In", "Out" or "Picked"? Regards, Fred "tran1728" wrote in message ... 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 . . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help for the formula
AMEND
"tran1728" wrote: 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" wrote: 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" wrote in message ... Hi, thanks for your reply, Pickcal", "In", "Out" or "Picked" , they are words "Fred Smith" wrote: You need to give us the rules. What determines whether it's "Pickcal", "In", "Out" or "Picked"? Regards, Fred "tran1728" wrote in message ... 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 . . |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help for the formula
=IF(AND(A1="",B1="",C1=""),"Pickcal",IF(AND(B10,A 1="",C1=""),"In",IF(AND(B10,C10,A1=""),"Out","Pi cked")))
Regards, Fred "tran1728" wrote in message ... 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 "Fred Smith" wrote: 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" wrote in message ... Hi, thanks for your reply, Pickcal", "In", "Out" or "Picked" , they are words "Fred Smith" wrote: You need to give us the rules. What determines whether it's "Pickcal", "In", "Out" or "Picked"? Regards, Fred "tran1728" wrote in message ... 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 . . |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help for the formula
you are the specialist, superb. Merci beaucoup.
Thanks so much. "tran1728" wrote: 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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help for the formula
Pas de quoi,
Fred "tran1728" wrote in message ... you are the specialist, superb. Merci beaucoup. Thanks so much. "tran1728" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
