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
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
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
Related:
- If statement
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- Excel if statement with text - Guide
- Vba case statement with string - Guide
- How many if statements can you nest - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Oct 22, 2015 at 07:48 AM
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.
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.
Oct 22, 2015 at 08:43 AM
Oct 24, 2015 at 06:14 AM
Oct 24, 2015 at 06:17 AM
You are a wizard!
Oct 24, 2015 at 06:23 AM
Thanks anyway.