Literal based on Week end

[Umar]

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?

 

[David Biddulph]

The syntax of the OR function is OR(condition1,condition2)

 

[Lars-Ã…ke Aspelin]

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: (e-mail address removed) ---

 

[Ms-Exl-Learner]

=IF(OR(D51="Sunday",D51="Saturday"),"No Hours Recorded","Charged")

Remember to Click Yes, if this post helps!

 

[Rick Rothstein]

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)

 

[T. Valko]

Cell D51 contains a formula -> =TEXT(B51,"dddd")

Another one...

=IF(LEFT(D51)="S","No Hours Recorded","Charged")