| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that will = 1 of 4 cell containing text
I have 4 cells BA8:BA11 Each one contains a if statement that returns text if it is true. Only one of the 4 can be true and all could be false. I want BA12 to return the text in the true cell and return "" if all are false. I tried this equation and a variation using ISBLANK =IF(ISTEXT(BA8),BA8,IF(ISTEXT(BA9),BA9,IF(ISTEXT(B A10),BA10,IF(ISTEXT(BA11),BA11,"")))) but it always returns "" even if there is a true result. Any other way to do this. -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=557073 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| How can I combine text and a function in a single cell | Excel Worksheet Functions | |||
Threaded Mode
