If statement [Solved/Closed]

Report
-
Posts
1004
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 27, 2020
-
Hi, Could you please tell me what I'm doing wrong in this statement?
I can't find the issue :(

=IF(AND(C2="Passed",D2="Passed",E2="Passed"), "Passed",IF(AND(C2="Not Started",D2="Not Started",E2="Not Started),"Not Started",IF(OR(C2="Failed",D2="Failed",E2="Failed"),"Failed","In Progress")))

Thanks,
Nuno

1 reply

Posts
1004
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 27, 2020
135
Hi Nuno,

It looks like you have forgotten a " at the end of your last 'Not Started' in the second AND statement.

Hope this helps. Let me know how it goes.
Thanks Brian, it worked :)
Posts
1004
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 27, 2020
135
Superb. Glad its sorted.
Posts
47365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 2, 2021
10,473 >
Posts
1004
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 27, 2020

Hi Brian, you old goat,
You are a wizard!
Posts
1004
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 27, 2020
135
nah - its a mistake I still make a lot. Im getting good at syntax! (or is it just syn????).

Thanks anyway.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!