| 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? |
| 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) | |||
Threaded Mode
