How do I make the FALSE go away?
 

=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<"ye s, no
",Data!A1))) but get same results.

Thanks for your help!

How do I make the FALSE go away?
 

=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="",D ata!A1,"Something else")))
or
=IF(D6="yes",Data!C2,IF(D6="no",Data!B3,
IF(trim(D6)="",Data!A1,"Something else")))

would be better.

scmoak14 wrote:

=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<"ye s, no
",Data!A1))) but get same results.

Thanks for your help!

--

Dave Peterson

How do I make the FALSE go away?
 

=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.

--
Biff
Microsoft Excel MVP


"scmoak14" wrote in message
...
=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<"ye s, no
",Data!A1))) but get same results.

Thanks for your help!

How do I make the FALSE go away?
 

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
"scmoak14" wrote:

=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<"ye s, no
",Data!A1))) but get same results.

Thanks for your help!

How do I make the FALSE go away?
 

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,""))

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"FloMM2" wrote:

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
"scmoak14" wrote:

=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<"ye s, no
",Data!A1))) but get same results.

Thanks for your help!