If statement

Solved/Closed

Nuno - 22 Oct 2015 à 03:54
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 - 24 Oct 2015 à 06:23

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

If statement
More than 1 if statement excel - Guide
Fenix internet on bank statement - Guide
Sbi account statement - Guide
Excel if statement with dates - Guide
Vba case statement with string - Guide

1 response

Réponse 1 / 1

BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 149
22 Oct 2015 à 07:48

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.

Nuno
22 Oct 2015 à 08:43

Thanks Brian, it worked :)

BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 149
24 Oct 2015 à 06:14

Superb. Glad its sorted.

Ambucias Posts 47312 Registration date Monday 1 February 2010 Status Moderator Last seen 28 March 2026 11,166 > BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021
24 Oct 2015 à 06:17

Hi Brian, you old goat,
You are a wizard!

BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 149
24 Oct 2015 à 06:23

nah - its a mistake I still make a lot. Im getting good at syntax! (or is it just syn????).

Thanks anyway.

Similar discussions

Excel - IF function with multiple words

Using IF function with dates

Excel "IF" function w/ date in test cell

How to use conditional format based on text?

Dates from an IF statement

Similar discussions

Subscribe To Our Newsletter!