Nesting If with And Functions Help Please

[pleased2help]

Hi can any one help me nesting 3 formula with If and statements, I cant get passed #Value

[pleased2help]

[QUOTE=pleased2help;8371]Hi can any one help me nesting 3 formula with If and statements, I cant get passed #Value

=IF(AND(A1=1,B1=1),C1*0.9,IF(AND(A1=2,B1=1),C1*0.9+2,IF(AND(A1=1,B1=2),C1*0.8,IF(AND(A1=2,B1=2),C1*0.8+2,IF(AND(A1=1,B1=3),C1*0.7,IF(AND(A1=2,B1=3),C1*0.7+2)))))) works for me