Quote:
Originally Posted by david_89_
=IF(ISNA(I2),H2,IF(AND(H2>0,I2<0),0,IF(AND(H2<0),( H2+I2)<0),I2,(H2-I2)))
|
What this will do is...
IF I2=NA() THEN H2
ELSEIF H2>0 AND I2<0 THEN 0
ELSEIF H2<0 AND H2+I2<0 THEN I2
ELSE H2-I2
I'm not surprised it doesn't work. :-)