Previous Topic Next Topic

If statement

Solved/Closed
Nuno - Oct 22, 2015 at 03:54 AM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Oct 24, 2015 at 06:23 AM
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 response

Answer 1 / 1
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 150
Oct 22, 2015 at 07:48 AM
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
Nuno
Oct 22, 2015 at 08:43 AM
Thanks Brian, it worked :)
0
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 150
Oct 24, 2015 at 06:14 AM
Superb. Glad its sorted.
0
Ambucias Posts 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,169 > BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021
Oct 24, 2015 at 06:17 AM
Hi Brian, you old goat,
You are a wizard!
0
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 150
Oct 24, 2015 at 06:23 AM
nah - its a mistake I still make a lot. Im getting good at syntax! (or is it just syn????).

Thanks anyway.
0

Similar discussions

Removing " false" value in "IF"
JIN -
share -

10 responses
Removing "FALSE" from an IF statement with a VLOOKUP
RayRay -
RayRay -

2 responses
removing false in excel
umer007 -
umer007 -

2 responses
Removing False Value
danmanuele -
ac3mark -

5 responses
Need help to remove FALSE from cell
TLP -
TLP -

4 responses