| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that will = 1 of 4 cell containing text
Hi,
notice that "" is text also, if the cells ba8:ba11 return "" too. hth regards from Brazil Marcelo "jermsalerms" escreveu: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that will = 1 of 4 cell containing text
=concatenate(ba8,ba9,ba10,ba11) Hth -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=557073 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that will = 1 of 4 cell containing text
The cells do result in "" if they are false So what is another way to do this...there must be some formula that will search BA8:BA11 for text that IS NOT "" and return the text in that cell. -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=557073 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that will = 1 of 4 cell containing text
Did you try the Concatenate? -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=557073 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that will = 1 of 4 cell containing text
Worked like a charm! Thanks! -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=557073 |
| Reply |
| 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 | |||
Linear Mode
