Upgrade to xl2007.

It added a new =iferror() function.

Excel ESG wrote:

Is there a way to error trap a formula without writing the formula 2 times,
the formula's are getting very long and hard to read / understand

--
Shared knowledge makes you smarter

"CLR" wrote:

=IF(AND(A1=-49,A1<=-29),"ok","")

=IF(A4=12,"OK","")

Wrap your formula in an Error Trap, as......

=IF(ISERR(YourFormula,"",YourFormula)

hth
Vaya con Dios,
Chuck, CABGx3



"Jake" wrote:

I need help in setting up a formula based upon a value. What i need is, if
the value of a specific cell is between -49 - 29, i need an "OK" in another
cell.
So, if the value of (A3) is 12, then i want an "OK" to automatically come up
in (A4).
Is this do-able? I know you can do "IF" formulas, but I cant find one that
fits.
Also, is there a way to turn a formula off if theres no value within a cell.
For example, i have a column titled "Bid" , one titled "Actual Amount" and
one titled "Difference." before the actual amount comes in, i leave the
cells blank, but i already have the "bid" amount and the formula specified in
"Actual Amount". So, i get a VALUE!# error message in my "Actual Amount"
cell.
I hope this makes sense. lol


--

Dave Peterson