2009/5/31 JOE Conner <[email protected]>: > 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
Yes, of course. Didn't think of that, but sure, it's obvious that you're right. I didn't even look at the formula with my brain switched on… =IF(OR(A1<0;B1<=0);"";(A1-B1)/B1) --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
