| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
| $C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give # | Excel Worksheet Functions | |||
| IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
| Macro to make all checkboxes false and clear all comboxes | Excel Discussion (Misc queries) | |||
| How can I make a True or False statement a certain color when usi. | Excel Worksheet Functions | |||
Linear Mode
