IF & AND

[Frank Bacchus]

Please let me know why this is not working:

=IF(AND(E2<> “Closed”,LEFT(B2,2)="DC","Active Queue"),IF(LEFT(B2,2)="CM",AM2,IF(LEFT(B2,2)="NS",AM2,B2)))

I am checking E2 NOT = "Closed" and IF the LEFT of B2,2 is "DC" - then set the results to "Active Queue" - otherwise, IF the LEFT of B2,2 is "CM" - then set the results to content of AM2, otherwise, IF the LEFT of B2,2 is "NS" - then set the results to content of AM2 ELSE Set the results to the content of B2,

I am getting #NAME. Can you shed some light on this? Thanks.

frank

 

[PaulF]

=IF(AND(E2<> "Closed",LEFT(B2,2)="DC"),"Active Queue",IF(LEFT(B2,2)="CM",AM2,IF(LEFT(B2,2)="NS",AM2,B2)))

Your quotes around Closed were some strange non-quotes... You syntax for your and statement wasn't correct... Check the changes... I did NOT check for accuracy to meet your requirements, just corrected syntax...

I hope this helps you!

Respectfully,
PaulF

 

[Frank Bacchus]

=IF(AND(E2<> "Closed",LEFT(B2,2)="DC"),"Active Queue",IF(LEFT(B2,2)="CM",AM2,IF(LEFT(B2,2)="NS",AM2,B2)))

Your quotes around Closed were some strange non-quotes... You syntax for your and statement wasn't correct... Check the changes... I did NOT check for accuracy to meet your requirements, just corrected syntax...

I hope this helps you!

Respectfully,
PaulF

PaulF:

Thanks. Perfect. I appreciate it.

frank