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

"greg071190" wrote in message
...

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