Think your use of AND in for eg this part:
.... IF(AND(M52="TOP HINGE-18 EXT",M52="TOP HINGE-24 EXT",
M52="TOP HINGE-30 EXT",M52="TOP HINGE-36 EXT",
M52="TOP HINGE-48 EXT"),3,...

should instead be an OR, viz it should be:
.... IF(OR(M52="TOP HINGE-18 EXT",M52="TOP HINGE-24 EXT",
M52="TOP HINGE-30 EXT",M52="TOP HINGE-36 EXT",
M52="TOP HINGE-48 EXT"),3,...

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cerberus" wrote:
Thank you Max, I will definitely try it your way since it seems easier.
Since I am new at this excel thing I would also like to know what I did wrong
in the formula I came up with so I dont have to bother anyone with a simple
IF/AND problem. Once again thank you for your help.