Help with Unparseable If(And) formula
Please help with reviewing the formula below. I am getting #UNPARSEABLE.
=IF(AND([Spend 2022]@row=0,[Spend 2023]@row=0,[Compliance Status]@row<>”ActiveNonCompliant”),"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!
Best Answer

Looks like you have slanted or "smart quotes" round your ”ActiveNonCompliant”, replace them with what you have on "Y" and "N"
=IF(AND([Spend 2022]@row = 0, [Spend 2023]@row = 0, [Compliance Status]@row <> "ActiveNonCompliant"), "Y", "N")
Answers

=IF(AND([Spend 2022]@row = 0, [Spend 2023]@row = 0, [Compliance Status]@row <> "ActiveNonCompliant"), "Y", "N")
I was able to get this formula to work under your same criteria.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

Looks like you have slanted or "smart quotes" round your ”ActiveNonCompliant”, replace them with what you have on "Y" and "N"
=IF(AND([Spend 2022]@row = 0, [Spend 2023]@row = 0, [Compliance Status]@row <> "ActiveNonCompliant"), "Y", "N")

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

Great!
Help Article Resources
Categories
Check out the Formula Handbook template!