Hello! I’m hoping someone can help me with a nested if statement. I am trying to list a specific price for a product or combination of products. Airtable keeps telling me that I have an invalid formula, please check formula text. Can anyone see anything specific here that needs to change?
Still getting an error. I looked at the Airtable knowledge base as well and enclosed all field references in curly brackets - although it didn’t seem to matter when I had only the first four lines up from the previous entry above, the formula worked then. Also changed all quotes to single straight quotes (They only come through here as curly).
Thank you so much! That helps a lot. One more question though, is the order of IF statements important? Some of my calculations in the sheet are not correct. Specifically, the calculations that include the different combinations. Should I be checking the conditions of the most complicated one first? and then start eliminating products?
The IF statements are evaluated in order and the first condition that is true determines the actual value.
This sometimes means that unlikely conditions and complicated conditions need to be placed earlier in the list. But this is not always the case. Thinking through the logic is often the hardest part of writing a formula (versus getting the punctuation right).