Help fix error with if and formula

Chevon Brownell

I am trying a formula and keep getting an error. Here is what I am trying =IF(and([Billing Status as of 04/10/2023]="Active",[Line Installation Date]@row="N/A"), "Unknown", IF(and([Billing Status as of 04/10/2023]="Inactive",[Line Installation Date]@row="N/A"), "N/A",IF([Installation Year]@row > 1988, "Yes", IF([Installation Year]@row < 1988, "No", "")))

Kelly Moore

Hey @Chevon Brownell

I’m assuming you’re getting an Unparseable error?

you are missing an @row in your first AND

kelly

Kelly Moore

Hey @Chevon Brownell

I’m assuming you’re getting an Unparseable error?

you are missing an @row in your first AND

kelly

Chevon Brownell

Thank you! Sometimes it just takes a second set of eyes.