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).