Help with an IF statement when using two fields

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have two different fields that I would prefer to combine into one so I can use it as a default filter more easily.  I am struggling to get it to work and could use some advise.  Here is the basic formula in each field:

Question A Status= If(([Question A])<>"","Question A Only", "Question A Not Answered")
Question B Status= If(([Question B])<>"","Question B Only", "Question B Not Answered")

Is it possible to combine these into one formula (I've tried but it is not working for me)?  If Question A or B are blank I really do not need a value -- I would rather it not auto-fill "blank", but I can't seem to get it to ignore it.  Any help is appreciated.  Should I be using Case instead of IF statement?

Thanks in advance!
Photo of Pro Survey Solutions

Posted 1 year ago

  • 0
  • 1
Please provide the desired result if the user enters:

Q1 only
Q2 only
Q1 and Q2 both
If the user answers only one or the other then it would display:

Q1 only -- would only display Question 1 answered 
Q2 only -- would only display Question 2 answered

If neither question answered it should be excluded.
If both questions answered, it is already covered by the above when both options are selected in the report.  Does this make sense?
Try this
IF(Trim([Question A])<>"", "Question A Answered"),
IF(Trim([Question B])<>"", "Question B Answered"))