Help for the formula
in [General]
|
Prev: Opening xlsx files in Excel 2000
Next: #VALUE!
From: tran1728 on 20 Mar 2010 16:10 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
From: tran1728 on 20 Mar 2010 16:13 "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
From: Fred Smith on 20 Mar 2010 17:22 You need to give us the rules. What determines whether it's "Pickcal", "In", "Out" or "Picked"? Regards, Fred "tran1728" <tran1728(a)discussions.microsoft.com> wrote in message news:C1B23721-3F1C-489F-A5F1-F58CFB1A99D6(a)microsoft.com... > 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
From: tran1728 on 20 Mar 2010 19:20 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" <tran1728(a)discussions.microsoft.com> wrote in message > news:C1B23721-3F1C-489F-A5F1-F58CFB1A99D6(a)microsoft.com... > > 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 > > . >
From: Fred Smith on 21 Mar 2010 13:34
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" <tran1728(a)discussions.microsoft.com> wrote in message news:99E69165-1ECC-4BB7-9F2B-5DEE17A09F7B(a)microsoft.com... > 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" <tran1728(a)discussions.microsoft.com> wrote in message >> news:C1B23721-3F1C-489F-A5F1-F58CFB1A99D6(a)microsoft.com... >> > 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 >> >> . >> |