MrExcel Publishing
Your One Stop for Excel Tips & Solutions

2 formulas in a cell?

Posted by rob on June 07, 2001 10:31 AM

Is there a way to put 2 formulas in a cell to achieve a multiple value "sentence"? For example, can I have the following formula: =IF(L5="","",L5) IF(M5="","","and the other customer is ") IF(M5="","",M5) to display the customer in L5, and if there is a customer in M5, display both L5, M5, and the string "and the other customer is". Or do I need to split the cells (which I'm trying to avoid doing for other reasons).

Posted by IML on June 07, 2001 10:43 AM

If I understand you correctly, try the following

=IF(L5="","",IF(M5="",L5,L5&" the other customer is "&M5))

Posted by rob on June 07, 2001 2:15 PM

yes, exactly, thank you