Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
2 formulas in a cell?
Posted by rob on June 07, 2001 10:31 AM
Hi,
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).
Thanks
Re: 2 formulas in a cell?
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))
Re: 2 formulas in a cell?
Posted by rob on June 07, 2001 2:15 PM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.