Hi,

I am trying to build a formula which allows the following conditions:

the formula is on cell J2:



-if H2<0 and H2+I2<0, return H2
-if H2<0 and I2 is N/A, return H2
-if H2>0 and I2<0, return 0

so far I have bould the following but it is not working:

=IF(ISNA(I2),H2,IF(AND(H2>0,I2<0),0,IF(AND(H2<0),( H2+I2)<0),I2,(H2-I2)))

Thank you very much in advance.

Regards,