[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
Bookmarks