Mar 18, 2017 10:31 AM
I’m having some trouble with my IF formula syntax. I want to determine if I need to file a state tax return for a real estate investment and I only need to do that when the property is equity or pref equity. I have a field called “Type” with a single-select list and I have a field called “Property State” that looks up the state in another table. I want my formula to say “If {Type} = Equity or Pref Equity then enter the value in Property State, else blank”. I don’t have trouble with the first part or the third part, but I can’t figure out the right syntax for the middle (enter the value from
Property State). I’m sure this is simple, so I’m hoping someone can easily help. Thank you!
Mar 18, 2017 03:56 PM
Linda,
I think this will work:
IF(OR({Type}="Equity",{Type}="Equity Pref"), {Property State}, "")
~ Tim
Mar 20, 2017 11:18 AM
Thank you so much! I was completely over-thinking it.