Help for the formula
in [General]
|
Prev: Opening xlsx files in Excel 2000
Next: #VALUE!
From: tran1728 on 21 Mar 2010 15:28 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" <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 > >> > >> . > >> > > . >
From: tran1728 on 21 Mar 2010 15:33 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" <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 > > >> > > >> . > > >> > > > > . > >
From: Fred Smith on 22 Mar 2010 16:10 =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" <tran1728(a)discussions.microsoft.com> wrote in message news:615D98C6-9B42-4E12-89A1-958CFBC338A5(a)microsoft.com... > 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" <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 >> >> >> >> . >> >> >> >> . >>
From: tran1728 on 22 Mar 2010 20:55 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
From: Fred Smith on 22 Mar 2010 22:06
Pas de quoi, Fred "tran1728" <tran1728(a)discussions.microsoft.com> wrote in message news:740E692F-B05F-49C8-83A7-F80B4FBE166D(a)microsoft.com... > 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 |