if Function

[ChetanPuri]

Hi team,

I am trying to create an if formula, if column C20 = Saturday, then Saturday or Sunday, and if Column B20 includes Sleepover then instead of Saturday or Sunday include Sleepover, other than that use same value in Column B. Not Sure why the formula doesn't work. Any help would be appreciated

Book3
	A	B	C
1	Monday	Night shift	Night shift
2	Tuesday	Night shift	Night shift
3	Wednesday	Night shift	Night shift
4	Thursday	Night shift	Night shift
5	Friday	Night shift	Night shift
6	Saturday	Night shift	Saturday
7	Sunday	Night shift	Sunday
8	Monday	Night shift	Night shift
9	Tuesday	Night shift	Night shift
10	Wednesday	Sleepover	Sleepover
11	Thursday	Sleepover	Sleepover
12	Friday	Sleepover	Sleepover
13	Saturday	Sleepover	Saturday
14	Sunday	Sleepover	Sunday
15	Monday	Sleepover	Sleepover
16	Tuesday	Sleepover	Sleepover
17	Wednesday	Sleepover	Sleepover
18	Thursday	Sleepover	Sleepover
19	Friday	Sleepover	Sleepover
20	Saturday	Sleepover	Saturday
21	Sunday	Sleepover	Sunday
22	Monday	Sleepover	Sleepover
23	Tuesday	Sleepover	Sleepover
24	Wednesday	Day shift	Day shift
25	Thursday	Day shift	Day shift
26	Friday	Day shift	Day shift
27	Saturday	Day shift	Saturday
Sheet1

Cell Formulas
Range	Formula
C1:C27	C1	=IF(A1="Saturday","Saturday",IF(A1="Sunday","Sunday",IF(B1="Sleepover","Sleepover",B1)))

 

[FormR]

Hi, it's not that clear to me from your description, so here's a bit of a guess. If this isn't it, re-post your example data, but complete column C manually with your expected results.

Book1
	A	B	C
1	Monday	Night shift	Monday
2	Tuesday	Night shift	Tuesday
3	Wednesday	Night shift	Wednesday
4	Thursday	Night shift	Thursday
5	Friday	Night shift	Friday
6	Saturday	Night shift	Saturday
7	Sunday	Night shift	Sunday
8	Monday	Night shift	Monday
9	Tuesday	Night shift	Tuesday
10	Wednesday	Sleepover	Wednesday
11	Thursday	Sleepover	Thursday
12	Friday	Sleepover	Friday
13	Saturday	Sleepover	Sleepover
14	Sunday	Sleepover	Sleepover
15	Monday	Sleepover	Monday
16	Tuesday	Sleepover	Tuesday
17	Wednesday	Sleepover	Wednesday
18	Thursday	Sleepover	Thursday
19	Friday	Sleepover	Friday
20	Saturday	Sleepover	Sleepover
21	Sunday	Sleepover	Sleepover
22	Monday	Sleepover	Monday
23	Tuesday	Sleepover	Tuesday
24	Wednesday	Day shift	Wednesday
25	Thursday	Day shift	Thursday
26	Friday	Day shift	Friday
27	Saturday	Day shift	Saturday
Sheet1

Cell Formulas
Range	Formula
C1:C27	C1	=IF(AND(OR(A1={"Saturday","Sunday"}),B1="Sleepover"),B1,A1)

 

[Scott Huish]

This is my guess as to what you need:
=IF(B1="Sleepover",B1,IF(OR(A1={"Saturday","Sunday"}),A1,B1))

 

[ChetanPuri]

This is my guess as to what you need:
=IF(B1="Sleepover",B1,IF(OR(A1={"Saturday","Sunday"}),A1,B1))

Thank you so much it worked.many thanks