Problems with IF, AND + OR statment

[alf bryn]

I have a range with data looking like this:

C D E
R6 max -2lgo 5,8
R7 max 5ppm 5,0
R8 min 5ppm 5,5
R9 max -2lgo 5,8
R10 max MK1 3,5

R = Row number

I want to "extract" the values from the E column to the G column if the
following coditions are met.

If C6 = max and D6 = -2 lgo or D6 = 5ppm I want the value of 5,8 in cell G6.
If any of these conditions are false I want G6 to show 0.

I have tried the following formulas:

=IF(AND(OR(C6="max";D6="-2 lgo";D6="5ppm"));E6;0)

This formula gives the result 5,5 in G8 insted of 0 and 3,5 in G10 insted
of 0. The other values are ok.

I have also tried

=IF(AND(C6="max";IF(OR(D6="-2 lgo";D6="5pp");E6));0)

This formula puts "FALSE" in G8 and G10 and 0 in G6, G7 and G9.

Would be gratefull for any help.

Using Excel 2002

 

[Anne Troy]

Try this, Alf.
=IF(AND(C6="max",OR(D6="-2lgo",D6="5ppm")),5.8,0)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[alf bryn]

Thanks Anne, you solved my problem!!!

Try this, Alf.
=IF(AND(C6="max",OR(D6="-2lgo",D6="5ppm")),5.8,0)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com