Help with Unparseable If(And) formula

RScapperotti

Please help with reviewing the formula below. I am getting #UNPARSEABLE.

=IF(AND([Spend 2022]@row=0,[Spend 2023]@row=0,[Compliance Status]@row<>”Active-NonCompliant”),"Y", "N")

If I only do the single IF, it returns the value correctly : =IF([Spend 2022]@row = 0, "Y", "N")

[Spend 2022] and [Spend 2023] columns are text (currency), and [Compliance Status] is a dropdown.

Thank you!

JMcI

Looks like you have slanted or "smart quotes" round your ”Active-NonCompliant”, replace them with what you have on "Y" and "N"

=IF(AND([Spend 2022]@row = 0, [Spend 2023]@row = 0, [Compliance Status]@row <> "Active-NonCompliant"), "Y", "N")

Colleen Patterson

@RScapperotti

=IF(AND([Spend 2022]@row = 0, [Spend 2023]@row = 0, [Compliance Status]@row <> "Active-NonCompliant"), "Y", "N")

I was able to get this formula to work under your same criteria.

JMcI

Looks like you have slanted or "smart quotes" round your ”Active-NonCompliant”, replace them with what you have on "Y" and "N"

=IF(AND([Spend 2022]@row = 0, [Spend 2023]@row = 0, [Compliance Status]@row <> "Active-NonCompliant"), "Y", "N")

RScapperotti

Thank you both! I copied and pasted your formulas and they worked. I believe it was the smart quotes.

JMcI

Great!