
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 18, 2017 03:56 PM
Linda,
I think this will work:
IF(OR({Type}="Equity",{Type}="Equity Pref"), {Property State}, "")
~ Tim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 20, 2017 11:18 AM
Thank you so much! I was completely over-thinking it.
