David, I agree with gebobs' diagnosis—that is, your IF formula does this:
Code:
If Then display
I2 is N/A H2
H2>0 and I2<0 0
H2<0 and H2+I2<0 I2
else H2-I2
In your original post you described what you want and it's somewhat different. But maybe that doesn't matter; instead, tell me
how it isn't working. What about the results don't you like?