	AllExperts > Excel
	Search

Volunteer
Answers to thousands of questions

Home · More Excel Questions · Answer Library

· Encyclopedia ·

Excel - Two formulaes in one cell?

Expert: Frank Dziubak - 2/13/2008

Question
Can we use two formulaes in one cell? if yes how? e.g. if I want to use (=BB20-BC20-BF20,=if BF>0,"Paid").

thanks and regards,

Sarfraz

Answer
Hi Sarfraz,

I think I see more or less what you are trying to do.

Let's assume that you have the following values in your cells:

BB20: 250
BC20: 25
BF20: 30

It looks like you want to put the result of BB20-BC20-BF20 together in the same cell with the word "PAID" (and perhaps "UNPAID" if the test is 0).

The process of joining two pieces of an answer together is called CONCATENATION. You can do it using the "ampersand" sign (&).
Your formula will then look like this:

=(BB20-BC20-BF20)&IF(BF20>0," Paid"," Unpaid")

Please let me know if this is the result you were hoping to get, or whether you need to further clarify your question. You can do so at FrankAtAllExperts@hotmail.com

-Frank

Add to this Answer Ask a Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here