View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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


.