Jump to content

Nested IF Logic


MariaAux

This topic is 4506 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm Web publishing a Database of children's games. There are 4 fields;

Preparation (sometimes empty)

How_to_Play (Always filled)

Variations (sometimes empty)

Notes (sometimes empty)

I am trying to create a nested IF function that only displays the field if it has some text in it. Just displaying one big blob of text listing field after field is obviously easy, but I want to add a header above each field if the field I included. I am getting stuck because the 1st, 3rd and 4th field are all variables. This is as far as I've got;

If (Preparation=0;"";"PREPARATION"&¶&How_to_Play)

Up until here is fine, but now adding the IF function if Variations or Notes are also empty by including/excluding them or their headers is getting me a little stuck. Any help would be HUGELY appreciated.

Thanks so much in advance,

Link to comment
Share on other sites

A few small points - 1) if you use two ¶ together, you must wrap them in quotes as "¶¶" so the above calc will throw a syntax error and 2) it is not necessary to list a default result when using If() or Case() (blank is assumed) so you can drop the "" results:

If ( not IsEmpty ( Preparation ) ; "Preparation¶" & Preparation & "¶¶" )

&

If ( not IsEmpty ( How_to_Play) ; "How To Play¶" & How_to_Play & "¶¶" )

&

If ( not IsEmpty ( Variations ) ; "Variations¶" & Variations & "¶¶" )

&

If ( not IsEmpty ( Notes ) ; "Notes¶" & Notes )

Link to comment
Share on other sites

This topic is 4506 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.