Thread: [Solved] IF + AND formula help
View Single Post
 
Old 06-11-2014, 11:07 AM
SarahBear SarahBear is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Jun 2014
Posts: 13
SarahBear is on a distinguished road
Default
you were missing an open parenthese after your second and, but beyond that they are right, your formula won't return what you want.

Try:

=IF(AND(H2<0,(H2+I2)<0),H2,IF(AND(H2<0,ISNA(I2)),H 2,IF(AND(H2>0,I2<0),0,(H2-I2))))
Reply With Quote