If statement not working

Robert S Fike

Can anyone see why this is not working. I keep getting #UNPARSEABLE.

=IF([Neighborhood Lots]@row = "Kinsley 50’", 45, IF([Neighborhood Lots]@row = "Kinsley 60’", 46, IF([Neighborhood Lots]@row = "Kinsley 70’", 47, IF([Neighborhood Lots]@row = "Kinsley 85’", 48, IF([Neighborhood Lots]@row = "Kinsley 100’", 49, IF([Neighborhood Lots]@row = "Hedgefield 50’", 43, IF([Neighborhood Lots]@row = "Hedgefield 60’", 44, IF([Neighborhood Lots]@row = "Stoneybrooke", 7F, IF([Neighborhood Lots]@row = "Woodland Creek 50’", 82, IF([Neighborhood Lots]@row = "Woodland Creek 60’", 83, IF([Neighborhood Lots]@row = "Woodland Creek 70’", 84, IF([Neighborhood Lots]@row = "Woodland Creek 85’", 85, IF([Neighborhood Lots]@row = "Woodland Creek 100’", 86, IF([Neighborhood Lots]@row = "Sturbride RB", 24, IF([Neighborhood Lots]@row = "Sturbridge Oaks", 25, IF([Neighborhood Lots]@row = "Sturbridge YC", 29, IF([Neighborhood Lots]@row = "Sturbride TR", 27, IF([Neighborhood Lots]@row = "Sturbridge PP", 28, IF([Neighborhood Lots]@row = "Wynrdige", 22, IF([Neighborhood Lots]@row = "New Park 50’", 92, IF([Neighborhood Lots]@row = "New Park 60’", 91, IF([Neighborhood Lots]@row = "New Park 75’", 90, IF([Neighborhood Lots]@row = "Summerlin", 94, IF([Neighborhood Lots]@row = "Camelot", 95, IF([Neighborhood Lots]@row = "Silver Hills", 26, IF([Neighborhood Lots]@row = "Cotton Terrace", 81, IF([Neighborhood Lots]@row = "Deer Creek", 65)))))))))))))))))))))))))))

Paul Newcome

Can you provide a screenshot of the formula open in the sheet as if you are about to edit it?

Andrée Starå

Hi @Robert S Fike

I hope you're well and safe!

At a glance, I can't see any issues. Have you double-checked the column names?

Try this and see if it makes a difference.

=

IF([Neighborhood Lots]@row = "Kinsley 50’", 45, 

IF([Neighborhood Lots]@row = "Kinsley 60’", 46, 

IF([Neighborhood Lots]@row = "Kinsley 70’", 47, 

IF([Neighborhood Lots]@row = "Kinsley 85’", 48, 

IF([Neighborhood Lots]@row = "Kinsley 100’", 49, 

IF([Neighborhood Lots]@row = "Hedgefield 50’", 43, 

IF([Neighborhood Lots]@row = "Hedgefield 60’", 44, 

IF([Neighborhood Lots]@row = "Stoneybrooke", 7F, 

IF([Neighborhood Lots]@row = "Woodland Creek 50’", 82, 

IF([Neighborhood Lots]@row = "Woodland Creek 60’", 83, 

IF([Neighborhood Lots]@row = "Woodland Creek 70’", 84, 

IF([Neighborhood Lots]@row = "Woodland Creek 85’", 85, 

IF([Neighborhood Lots]@row = "Woodland Creek 100’", 86, 

IF([Neighborhood Lots]@row = "Sturbride RB", 24, 

IF([Neighborhood Lots]@row = "Sturbridge Oaks", 25, 

IF([Neighborhood Lots]@row = "Sturbridge YC", 29, 

IF([Neighborhood Lots]@row = "Sturbride TR", 27, 

IF([Neighborhood Lots]@row = "Sturbridge PP", 28, 

IF([Neighborhood Lots]@row = "Wynrdige", 22, 

IF([Neighborhood Lots]@row = "New Park 50’", 92, 

IF([Neighborhood Lots]@row = "New Park 60’", 91, 

IF([Neighborhood Lots]@row = "New Park 75’", 90, 

IF([Neighborhood Lots]@row = "Summerlin", 94, 

IF([Neighborhood Lots]@row = "Camelot", 95, 

IF([Neighborhood Lots]@row = "Silver Hills", 26, 

IF([Neighborhood Lots]@row = "Cotton Terrace", 81, 

IF([Neighborhood Lots]@row = "Deer Creek", 65)

Did it work?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Robert S Fike

I did. the columns are the same. I will try yours and let you know. Thank you very much

Robert S Fike

This was causing the issue thus far. Still typing. Had to list it as "7F" and not just 7F.

Andrée Starå

@Robert S Fike

Oh, good catch!

I don't see any others, so try it now and see if it works.

Robert S Fike

That fixed it