Literal based on Week end
in [Functions]
|
Prev: Excel 2007 AutoSaves
Next: Alternate row comparison
From: Umar on 26 Dec 2009 08:53 I tried these to NO avail: Cell D51 contains a formula -> =TEXT(B51,"dddd") For Cell E51 I want to enter an IF condition based upon the Weekday value in Cell D51. So, here is what I have tried and I also have tried some other variations: 1. IF(D51="Sunday" OR D51= "Saturday","No Hours Recorded","Charged") 2. IF(D51='Sunday' OR D51= 'Saturday','No Hours Recorded','Charged') All failed, could anyone pinpoint and corrected the typo?
From: "David Biddulph" groups [at] on 26 Dec 2009 09:24 The syntax of the OR function is OR(condition1,condition2) -- David Biddulph "Umar" <Umar(a)discussions.microsoft.com> wrote in message news:A2D91C43-8BBD-44E2-BDFA-BB83EEA51F7C(a)microsoft.com... >I tried these to NO avail: > Cell D51 contains a formula -> =TEXT(B51,"dddd") > > For Cell E51 I want to enter an IF condition based upon the Weekday value > in > Cell D51. > > So, here is what I have tried and I also have tried some other variations: > > 1. IF(D51="Sunday" OR D51= "Saturday","No Hours Recorded","Charged") > > 2. IF(D51='Sunday' OR D51= 'Saturday','No Hours Recorded','Charged') > > All failed, could anyone pinpoint and corrected the typo?
From: Ms-Exl-Learner on 26 Dec 2009 09:47 =IF(OR(D51="Sunday",D51="Saturday"),"No Hours Recorded","Charged") Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Umar" wrote: > I tried these to NO avail: > Cell D51 contains a formula -> =TEXT(B51,"dddd") > > For Cell E51 I want to enter an IF condition based upon the Weekday value in > Cell D51. > > So, here is what I have tried and I also have tried some other variations: > > 1. IF(D51="Sunday" OR D51= "Saturday","No Hours Recorded","Charged") > > 2. IF(D51='Sunday' OR D51= 'Saturday','No Hours Recorded','Charged') > > All failed, could anyone pinpoint and corrected the typo?
From: Lars-Åke Aspelin on 26 Dec 2009 09:44 "Umar" <Umar(a)discussions.microsoft.com> wrote in message news:A2D91C43-8BBD-44E2-BDFA-BB83EEA51F7C(a)microsoft.com... >I tried these to NO avail: > Cell D51 contains a formula -> =TEXT(B51,"dddd") > > For Cell E51 I want to enter an IF condition based upon the Weekday value > in > Cell D51. > > So, here is what I have tried and I also have tried some other variations: > > 1. IF(D51="Sunday" OR D51= "Saturday","No Hours Recorded","Charged") > > 2. IF(D51='Sunday' OR D51= 'Saturday','No Hours Recorded','Charged') > > All failed, could anyone pinpoint and corrected the typo? The syntax for OR is not correct. Try this: =IF( OR ( D51="Sunday", D51 = "Saturday"), "No Hours Recorded", "Charged" ) Hope this helps / Lars-Åke --- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---
From: Rick Rothstein on 26 Dec 2009 10:59
As others have told you, your syntax for the OR was incorrect (it is a function, not an operator); however, for your particular formula, you don't need to use OR at all; here is an alternative... =IF(WEEKDAY(B51,2)>5,"No Hours Recorded","Charged") Note the argument for the WEEKDAY function is B51... your actual date, not D51 which only contains the text for the day of the week... and that the 2 tells the WEEKDAY function to count the days of the week starting with Monday; hence, Saturday would be day number 6 and Sunday would be day number 7, which is why the test I use is >5 (you could use >=6 if you wanted to) -- Rick (MVP - Excel) "Umar" <Umar(a)discussions.microsoft.com> wrote in message news:A2D91C43-8BBD-44E2-BDFA-BB83EEA51F7C(a)microsoft.com... >I tried these to NO avail: > Cell D51 contains a formula -> =TEXT(B51,"dddd") > > For Cell E51 I want to enter an IF condition based upon the Weekday value > in > Cell D51. > > So, here is what I have tried and I also have tried some other variations: > > 1. IF(D51="Sunday" OR D51= "Saturday","No Hours Recorded","Charged") > > 2. IF(D51='Sunday' OR D51= 'Saturday','No Hours Recorded','Charged') > > All failed, could anyone pinpoint and corrected the typo? |