Nested if statements comparing four columns getting a FALSE result

Hello,

I'm trying to compare four columns. I've attached a short example with my formula under the Overall Status column. Here is my formula for discussion if others cannot see attachment

=IF(A2="TRUE",IF(B2<>"",IF(C2<>"",IF(D2="Complete","Done","Pending"))))

A2____B2__________________C2____________________D2
True___6/18/2019 7:00:00 AM__7/17/2018 7:00:00 AM __Complete
True_______________________7/17/2018 7:00:00 AM __ Submitted
True __7/17/2018 7:00:00 AM _______________________Submitted
True___6/18/2019 7:00:00 AM__7/17/2018 7:00:00 AM___Submitted

I keep getting the result FALSE when it needs to provide Done or Pending.

Getting frustrated because I cannot see what is wrong with my formula.

Your assistance would be greatly appreciated.

Bev

How about
=IF(AND(A2,B2<>"",C2<>"",D2="Complete"),"Done","Pending")

You're formula will always return false as you have TRUE wrapped in quotes, which should not be there. Also you have not supplied a false argument to any of the IFs.

Like Fluff says:
If you want to retain your formula then you should:

1. remove quotes "" from the word TRUE.
2. add 'value if false' to each of your nested IFS like this:
=IF(A2=TRUE,IF(B2<>"",IF(C2<>"",IF(D2="Complete","Done","Pending"),"Pending"),"Pending"),"Pending")

You're welcome & thanks fr the feedback.
In your sample file it had a boolean term TRUE, which is not text & therefore should not have the quotes.

Belinda200,
Thank you for your example. The example showed me right where I was making the mistake. After I changed my formula everything worked!

You're welcome