Can I put 2 formulars in one cell
 

=(a1*4)+(a2*5)
--
Don Guillett
SalesAid Software

"greg071190" wrote in message
...

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

"Peo Sjoblom" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

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

"Peo Sjoblom" wrote:

Hi

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

Arvi Laanemets


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

"Peo Sjoblom" wrote:

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

"greg071190" wrote:

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

"Peo Sjoblom" wrote:

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