Hi Steve
=IF(OR(A1<0,A185),"Error",""))

--
Regards

Roger Govier


"SteveC" wrote in message
...
Ok, I have this formula with 3 nested if statements, referencing
another part
of the worksheet so I can toggle between -1 and 85, let's say.

No need to reprint the exact formula, it's a generic nested if
formula. If
the value returned by the formula is above 80 or below 0, or returns
an
error, it leaves the cell blank.

It's an ugly nested if formula. Wondering if there is a better way?

Thanks...