If statement

Solved/Closed
Report
-
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
-
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
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
146
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.
0
Thanks Brian, it worked :)
0
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
146
Superb. Glad its sorted.
0
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,366 >
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021

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

Thanks anyway.
0