Skip to main content

"If" formula syntax that evaluates one field and enters info from another field

  • March 18, 2017
  • 2 replies
  • 49 views

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!

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+4
  • Known Participant
  • March 18, 2017

Linda,

I think this will work:

IF(OR({Type}="Equity",{Type}="Equity Pref"), {Property State}, "")

~ Tim


  • Author
  • New Participant
  • March 20, 2017

Linda,

I think this will work:

IF(OR({Type}="Equity",{Type}="Equity Pref"), {Property State}, "")

~ Tim


Thank you so much! I was completely over-thinking it.