How do I make the FALSE go away?

  • Thread starter Thread starter scmoak14
  • Start date Start date
S

scmoak14

=IF(D6="yes",Data!C2,IF(D6="no",Data!B3,IF(D6=" ",Data!A1)))

Intent is that if D6 is empty, E6 is also empty. With this formula when D6
is empty E6 displays as FALSE.

I also tried =IF(D6="yes",Data!C2,IF(D6="no",Data!B3,IF(D6<>"yes, no
",Data!A1))) but get same results.

Thanks for your help!
 
=IF(D6="yes",Data!C2,IF(D6="no",Data!B3,IF(D6=" ",Data!A1,"Something else")))

And are you sure you want to test D6 against a single space character?

I would think:
=IF(D6="yes",Data!C2,IF(D6="no",Data!B3,IF(D6="",Data!A1,"Something else")))
or
=IF(D6="yes",Data!C2,IF(D6="no",Data!B3,
IF(trim(D6)="",Data!A1,"Something else")))

would be better.
 
=IF(D6="yes",Data!C2,IF(D6="no",Data!B3,IF(D6=" ",Data!A1)))

Try it like this:

=IF(D6="yes",Data!C2,IF(D6="no",Data!B3,IF(D6=" ",Data!A1,"")))

Are you sure you want this test:

IF(D6=" "

You're testing the cell for a space character. This not the same as testing
the cell for being blank.
 
scmoak14,
What it looks like to my untrained eye, the good one. lol
Is this:
With an "IF" statement, there is a logical test, value if true, value if
false format.
When we link them together, we have to watch that it still maintains the
format.
With that in mind, your formula
"=IF(D6="yes",Data!C2,IF(D6="no",Data!B3,IF(D6=" ",Data!A1)))" is in cell E6.
So, I think it should read,
"=IF(D6="yes",Data!C2,IF(D6="no",Data!B3,IF(D6="","")))"
hth
 
I would think that with yes/no being the only results you want a value
response for, ALL other values including blank should return the same null
result, like so:

=IF(D6="yes",Data!C2,IF(D6="no",Data!B3,""))
 
Back
Top