Trouble creating a text formula based on null fields

I hate nested IFs.  Too hard to debug especially if you have to revisit is 2 months to 2 weeks later.

Conversely I LOVE formula variables. http://help.quickbase.com/user-assistance/formula_variables.html


I would do this.

var text TestTypes = 

If(

Trim([Type3 - Third Type])=""  and Trim([Type2 - Second Type])="" and Trim([Type1 - First Type])<>"",[Type1 - First Type],

Trim([Type3 - Third Type])="" and Trim([Type2 - Second Type])<>"" and Trim([Type1 - First Type])<>"",[Type2 - Second Type],

Trim([Type3 - Third Type])<>"" and Trim([Type2 - Second Type])<>"" and Trim([Type1 - First Type])<>"",[Type3 - Third Type]);



IF(Trim([Type of Claim or Project])<>"", $TestTypes)