Whats wrong withthe following formula,
=IF(A32="Door Panel",IF(B32<0>1200,2,IF(B32<1200>1600,3,IF(B32<1600>2100,4,IF(B32>2100,5,0)))))
What I'm trying to do is,the cell A32 has "Door Panel" in it and the sell B32 is less than 1200 insert 2 however if the sell B32 is greater than 1200 and less than 1600 then insert 3 and so on then if none of the criteria match insert 0.
=IF(A32="Door Panel",IF(B32<0>1200,2,IF(B32<1200>1600,3,IF(B32<1600>2100,4,IF(B32>2100,5,0)))))
What I'm trying to do is,the cell A32 has "Door Panel" in it and the sell B32 is less than 1200 insert 2 however if the sell B32 is greater than 1200 and less than 1600 then insert 3 and so on then if none of the criteria match insert 0.