Grouping IF/AND/OR in a single formula

B

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
 
J

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
 
J

JoeU2004

Brad Wolosz said:
Here is what I am trying to acomplish
IF H2=0 AND I2=0, ""
IF H2>0 AND I2=0 "1"
ELSE I2/H2
Click to expand...

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


----- original message -----
 
Top