Johnny Rosenberg wrote:
Maybe I misunderstood the question, but what if both A1 and B1 are
negative? If that also should give a blank C1, the formula you got was
correct (I guess, I didn't study it closer, but it looks correct).
However, you can obtain the same thing with the OR function and it
might look a little bit more straight forward:
=IF(OR(A1<0;B1<0);"";(A1-B1)/B1)
This means (and this is only for a quick explanation, you can't enter
it this way, of course): IF A1<0 OR B1<0 THEN "" ELSE (A1-B1)/B1
Johnny Rosenberg
<<SNIP>>
I feel constrained to point out that if B=0 your formula will fail. You
need the less than symbol changed to equals or less than. e.g. B<=0.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
