Grouping IF/AND/OR in a single formula

[Brad Wolosz]

Hi all

I am trying to creat a formula by grouping multiple conditions
and just cant seem to get it to work

Any ideas would be of great help

Here is what I am trying to acomplish

IF H2=0 AND I2=0, ""
IF H2>0 AND I2=0 "1"
ELSE I2/H2

Thanks for any input given

Brad

 

[ryguy7272]

=IF(AND(H2=0,I2=0),"",IF(AND(H2>0,I2=0),"1",I2/H2))

HTH,
Ryan---

 

[Jan Nademlejnsky]

H1 I1 Results
0.0 0.0
10.0 0.0 1.0
6.0 5.0 0.8
0.3 0.1 0.4
1.0 0.8 0.8
0.3 0.2 0.8
0.6 0.0 1.0
0.5 0.5 1.0
0.0 0.6
0.5 0.1 0.2


=IF(H2=0,IF(I2=0,""),IF(I2=0,1,I2/H2))
Note that your described condition would produce error if H2 = 0, but I2 >0

Jan

 

[JoeU2004]

Here is what I am trying to acomplish
IF H2=0 AND I2=0, ""
IF H2>0 AND I2=0 "1"
ELSE I2/H2

=if(or(I2<>0,H2<0),I2/H2,if(H2>0,"1",""))


----- original message -----