Nested IF?

[excel707]

I am setting up a work schedule and I am trying to create a formula that will check to make sure that each day at least has a day (D) and a grave (G) shift assigned to an employee. If it does not have one of the two shifts, I would like for the missing shift to appear only in row 4. I think I may need a nested IF to accomplish this?

The latest formula I tried is:

=IF(ISNUMBER(FIND("D",Q6:Q11))=FALSE,"D",IF(ISNUMBER(FIND("G",Q6:Q11))=FALSE,"G",""))

As you can see, I have a D in Q7 but it still resulted in displaying a D in Q4....

I have figured out how to accomplish this when putting the results in two different rows but I would like to have the result come back in the same row. I successfully used the formulas below:
=IF(AND(I6<>"D",I7<>"D",I8<>"D",I9<>"D",I10<>"D",I11<>"D"),"D","")
=IF(AND(I6<>"G",I8<>"G",I9<>"G",I10<>"G",I11<>"G",I7<>"G"),"G","")

 

[Special-K99]

"to make sure each day has a D and G shift"

Where are your days listed? The diagram does not show separate days.

 

[Fluff]

Maybe
=IF(COUNTIF(C6:C11,"D")=0,"D",IF(COUNTIF(C6:C11,"G")=0,"G",""))

 

[excel707]

"to make sure each day has a D and G shift"

Where are your days listed? The diagram does not show separate days.

I cut it off by accident...

 

[excel707]

Maybe
=IF(COUNTIF(C6:C11,"D")=0,"D",IF(COUNTIF(C6:C11,"G")=0,"G",""))

Hey, this seems to be working. Thank you! For my own reference, what type of formula is this called?

 

[Fluff]

You're welcome & thanks for the feedback.

I wouldn't say it has a particular name, but it's a type of nested formula in that you have functions inside other functions.