| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I nest IF statements to only return value if both true?
I have a cell, M30, in which I want to display contents copied from another
cell (D18), provided that two different conditions are met: K24=Y and M29 has some text content in it already. Otherwise, M30 is blank. The basic IF statement I've written for M30 is =IF(k24="y",D18,""), but that only takes care of the first condition. How do I make it test for the second condition, that M29 has some text in it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I nest IF statements to only return value if both true?
Hi!
Try this: =IF(AND(K24="Y",M29<""),D18,"") Biff "kvnexcel" wrote in message ... I have a cell, M30, in which I want to display contents copied from another cell (D18), provided that two different conditions are met: K24=Y and M29 has some text content in it already. Otherwise, M30 is blank. The basic IF statement I've written for M30 is =IF(k24="y",D18,""), but that only takes care of the first condition. How do I make it test for the second condition, that M29 has some text in it? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I nest IF statements to only return value if both true?
BIFF -- Worked like a charm! Thanks.
"Biff" wrote: Hi! Try this: =IF(AND(K24="Y",M29<""),D18,"") Biff "kvnexcel" wrote in message ... I have a cell, M30, in which I want to display contents copied from another cell (D18), provided that two different conditions are met: K24=Y and M29 has some text content in it already. Otherwise, M30 is blank. The basic IF statement I've written for M30 is =IF(k24="y",D18,""), but that only takes care of the first condition. How do I make it test for the second condition, that M29 has some text in it? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I nest IF statements to only return value if both true?
You're welcome. Thanks for the feedback!
Biff "kvnexcel" wrote in message ... BIFF -- Worked like a charm! Thanks. "Biff" wrote: Hi! Try this: =IF(AND(K24="Y",M29<""),D18,"") Biff "kvnexcel" wrote in message ... I have a cell, M30, in which I want to display contents copied from another cell (D18), provided that two different conditions are met: K24=Y and M29 has some text content in it already. Otherwise, M30 is blank. The basic IF statement I've written for M30 is =IF(k24="y",D18,""), but that only takes care of the first condition. How do I make it test for the second condition, that M29 has some text in it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Easy formula to return a true or false | Excel Worksheet Functions | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| How do I return True False | Excel Worksheet Functions | |||
| Macros and Toolbars | Excel Discussion (Misc queries) | |||
Hybrid Mode
