Nested IF

A

Anita

I've got a nested IF in Excel which works fine and want to include it as a
column in a query as a calculated field. I've read lots of posts similar to
this one but just can't seem to get it working. Can anyone help? Here's the
formula in Excel...

=IF(AND(B2>0.1,B2<=0.25),"H5_H7",IF(AND(B2>0.25,B2<=1),"H5_H7_H14",IF(AND(B2>1,B2<=5),"H5_H7_H11_H14",IF(AND(B2>5,B2<=7),"H5_H7_H10_H11_H14",IF(B2>7,"H6_H7_H10_H11_H14","Non-Haz")))))

Many thanks in anticipation!

Anita
 
O

Ofer Cohen

Using IIF Try something like :

=IIF(B2>0.1 And B2<=0.25,"H5_H7",IIF(B2>0.25 And B2<=1,"H5_H7_H14",IIF(B2>1
And B2<=5,"H5_H7_H11_H14",IIF(B2>5 And B2<=7,"H5_H7_H10_H11_H14","Non-Haz"))))
 
A

Anita

Thankyou thankyou thankyou - it worked !!!


Ofer Cohen said:
Using IIF Try something like :

=IIF(B2>0.1 And B2<=0.25,"H5_H7",IIF(B2>0.25 And B2<=1,"H5_H7_H14",IIF(B2>1
And B2<=5,"H5_H7_H11_H14",IIF(B2>5 And B2<=7,"H5_H7_H10_H11_H14","Non-Haz"))))
Click to expand...
 
Top