Literal based on Week end
 

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?

Literal based on Week end
 

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

"Umar" wrote in message
...
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?

Literal based on Week end
 

"Umar" wrote in message
...
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: ---

Literal based on Week end
 

=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?

Literal based on Week end
 

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" wrote in message
...
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?

Literal based on Week end
 

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

Another one...

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

--
Biff
Microsoft Excel MVP


"Umar" wrote in message
...
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?