View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cerberus Cerberus is offline
external usenet poster
 
Posts: 88
Default The error of my ways.

in the function below, I am having an issue with 3 and 6 showing up in the
cell. 0,1,2,4,5 all come up fine but I seem to have an issue after the
IF/AND. Can anyone see what I did wrong. Thanks for any help

=IF(M52="TOP HINGE-0 EXT",1,IF(M52="TOP HINGE-12 EXT",2,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,IF(M52="OFFSET TOP HINGE-0
EXT",4,IF(M52="OFFSET TOP HINGE-12 EXT",5,IF(AND(M52="OFFSET TOP HINGE-18
EXT",M52="OFFSET TOP HINGE-24 EXT",M52="OFFSET TOP HINGE-30 EXT",M52="OFFSET
TOP HINGE-36 EXT",M52="OFFSET TOP HINGE-48 EXT"),6,0))))))