Can I put 2 formulars in one cell

F

Frank Kabel

Hi
you really have to explain what you're trying to achieve with this. How
should these two formulas be combined?. Do you mean:
=IF(J26-(F26+G26)<=100,"Within budget","Over budget")
 
A

Arvi Laanemets

Hi

=(J26-(F26+G26)) & IF(A2<=100," Within budget"," Over budget")
but it is still one formula :))

Arvi Laanemets
 
P

Peo Sjoblom

Yes, almost

=IF(A2<=100,TEXT(J26-(F26+G26),"$#,##0.00")&" Within
budget",TEXT(J26-(F26+G26),"$#,##0.00")&" Over budget")

or just

=J26-(F26+G26)&IF(A2<=100," Within budget"," Over budget")

Regards,

Peo Sjoblom
 
T

Tim C

Did you intend for this formula to be in A2?

If so, try:

=J26-(F26+G26)&IF(J26-(F26+G26)<=100,"Within budget","Over budget")

You can add number formatting with a TEXT function:

=TEXT(J26-(F26+G26),"0.00")&IF(J26-(F26+G26)<=100," Within budget"," Over
budget")

Either of these two methods will end up with text in the cell.

To leave numbers in the cell, just use the calculation:

=J26-(F26+G26)

And then use the custom numer format:

[<=100]0.00 "within budget";[>100]0.00 "overbudget";General

But all of these methods have disadvantages, and I would recommend putting
the two formulas in separate cells.

Tim C
 
Top