software

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...
Hi Steve
=IF(OR(A1lt;0,A1gt;85),quot;Errorquot;,quot;quot;))

--
Regards

Roger Govierquot;SteveCquot; gt; wrote in message
...
gt; Ok, I have this formula with 3 nested if statements, referencing
gt; another part
gt; of the worksheet so I can toggle between -1 and 85, let's say.
gt;
gt; No need to reprint the exact formula, it's a generic nested if
gt; formula. If
gt; the value returned by the formula is above 80 or below 0, or returns
gt; an
gt; error, it leaves the cell blank.
gt;
gt; It's an ugly nested if formula. Wondering if there is a better way?
gt;
gt; Thanks...
gt;
gt;
Roger thanks... how do I use your formula in this context:

=IF(ISERROR(G30/H30),quot;quot;,IF((G30/H30)gt;85,quot;quot;,IF((G30/H30)lt;0,quot;quot;,G30/H30)))

where G30/H30 is the formula that should return a blank cell if an error,
above 85 or below 0? The above formula works, but curious how to use your OR
formula instead?

Thanks a lot!

SteveC

quot;Roger Govierquot; wrote:

gt; Hi Steve
gt; =IF(OR(A1lt;0,A1gt;85),quot;Errorquot;,quot;quot;))
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;SteveCquot; gt; wrote in message
gt; ...
gt; gt; Ok, I have this formula with 3 nested if statements, referencing
gt; gt; another part
gt; gt; of the worksheet so I can toggle between -1 and 85, let's say.
gt; gt;
gt; gt; No need to reprint the exact formula, it's a generic nested if
gt; gt; formula. If
gt; gt; the value returned by the formula is above 80 or below 0, or returns
gt; gt; an
gt; gt; error, it leaves the cell blank.
gt; gt;
gt; gt; It's an ugly nested if formula. Wondering if there is a better way?
gt; gt;
gt; gt; Thanks...
gt; gt;
gt; gt;
gt;
gt;
gt;

quot;SteveCquot; gt; wrote in message
...

gt; quot;Roger Govierquot; wrote:
gt;gt; quot;SteveCquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Ok, I have this formula with 3 nested if statements, referencing
gt;gt; gt; another part
gt;gt; gt; of the worksheet so I can toggle between -1 and 85, let's say.
gt;gt; gt;
gt;gt; gt; No need to reprint the exact formula, it's a generic nested if
gt;gt; gt; formula. If
gt;gt; gt; the value returned by the formula is above 80 or below 0, or returns
gt;gt; gt; an
gt;gt; gt; error, it leaves the cell blank.
gt;gt; gt;
gt;gt; gt; It's an ugly nested if formula. Wondering if there is a better way?
gt;gt; gt;
gt;gt; gt; Thanks...

gt;gt; Hi Steve
gt;gt; =IF(OR(A1lt;0,A1gt;85),quot;Errorquot;,quot;quot;))

gt; Roger thanks... how do I use your formula in this context:
gt;
gt; =IF(ISERROR(G30/H30),quot;quot;,IF((G30/H30)gt;85,quot;quot;,IF((G30/H30)lt;0,quot;quot;,G30/H30)))
gt;
gt; where G30/H30 is the formula that should return a blank cell if an error,
gt; above 85 or below 0? The above formula works, but curious how to use your
gt; OR
gt; formula instead?

You could try
=IF(ISERROR(G30/H30),quot;quot;,IF(OR(G30/H30lt;0,G30/H30gt;85),quot;quot;,G30/H30))
[... but unfortunately
=IF(OR(ISERROR(G30/H30),G30/H30lt;0,G30/H30gt;85),quot;quot;,G30/H30) doesn't work].
--
David Biddulph
Roger and David, Thank you!