#VALUE! Error

[JeffJ]

Why does the following formula give me a #VALUE! error?

=IF(AND(OR(E7="E-120-D",E8="E-120-D",E9="E-120-D",E10="E-120-D",E11="E-120-D",E12="E-120-D",E13="E-120-D",E14="E-120-D",E15="E-120-D",E16="E-120-D"),OR("38X12","40X12","42X12","44X12","46X12","48X12","50X12","52X12","54X12","56X12","58X12","60X12","62X12","64X12","66X12","68X12","70X12"),E2="...3/12...",E3="1
inch"),1,"")

Thank you for any reply

 

[Chip Pearson]

The problem is in the second OR function. OR requires conditional
tests or numeric values as its parameters. You are passing
strings. OR returns #VALUE if one or more of its arguments is
text.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[JeffJ]

I apologize for posting without checking my formula more carefully.
was missing a cell reference (E6). It now works correctly, with n
more #VALUE! error:

=IF(AND(OR(E7="E-120-D",E8="E-120-D",E9="E-120-D",E10="E-120-D",E11="E-120-D",E12="E-120-D",E13="E-120-D",E14="E-120-D",E15="E-120-D",E16="E-120-D"),OR(E6="38X12",E6="40X12",E6="42X12",E6="44X12",E6="46X12",E6="48X12",E6="50X12",E6="52X12",E6="54X12",E6="56X12",E6="58X12",E6="60X12",E6="62X12",E6="64X12",E6="66X12",E6="68X12",E6="70X12"),E2="...3/12...",E3="1
inch"),1,""

 

[Jason Morin]

The second OR section is not set up properly:

....OR("38X12","40X12",...

You need to reference a cell just as you did in the first
OR statement. Use something like:

....OR(E7="38X12",E8="40X12",...

HTH
Jason
Atlanta, GA

 

[JeffJ]

Thank you, Chip and Jason, for your fast replies.


-Jeff
(e-mail address removed)