Nested IF(AND formula not being accepted...

[QutieJsMom]

PLEASE HELP! I've entered this nested formula and Excel is not accepting it. For the life of me I can't see what I've left out or put in that's not working. I haven't used nested formulas for awhile so I'm rusty and hoping this is something simple I've over looked. Thanks in advance for your help! =IF(AND(G4="Friday",G6="A"),Schedule!D2,=IF(AND(G4="Friday",G6="B"),Schedule!E2,=IF(G6="A",Schedule!B2,=IF(G6="B",Schedule!C2,""))))

 

[AhoyNC]

Looks like too many = signs before the if. Try:

=IF(AND(G4="Friday",G6="A"),Schedule!D2,IF(AND(G4="Friday",G6="B"),Schedule!E2,IF(G6="A",Schedule!B2,IF(G6="B",Schedule!C2,""))))

 

[joeu2004]

For the life of me I can't see what I've left out or put in that's not working.
[....]

=IF(AND(G4="Friday",G6="A"),Schedule!D2,=IF(AND(G4="Friday",G6="B"),Schedule!E2,
=IF(G6="A",Schedule!B2,=IF(G6="B",Schedule!C2,""))))

Too many equal signs ("="). The syntax should be:

=IF(AND(G4="Friday",G6="A"),Schedule!D2,IF(AND(G4="Friday",G6="B"),Schedule!E2,
 IF(G6="A",Schedule!B2,IF(G6="B",Schedule!C2,""))))

But you can simplify as follows:

=IF(G6="A",IF(G4="Friday",Schedule!D2,Schedule!B2),
 IF(G6="B",IF(G4="Friday",Schedule!E2,Schedule!C2),""))

 

[QutieJsMom]

Thank you all!! I figured it was something as simple as that. It does indeed work much better if I remove the = before all but the first IF! Works nicely. Joeu2004, I love your further suggestion of simplifying it! I see what cha did there & will use it. THANK YOU THANK YOU THANK YOU!! This is my first post here. Is there a rewards system for best answer or anything that I need to take care of or to mark this thread as solved?

 

[joeu2004]

Joeu2004, I love your further suggestion of simplifying it! I see what cha did there & will use it. THANK YOU THANK YOU THANK YOU!! This is my first post here. Is there a rewards system for best answer

I don't know. And honestly, I don't care about such things. My reward comes from your satisfaction with an answer. Thanks for the feedback.

or anything that I need to take care of or to mark this thread as solved?

Apparently not in this forum.