Hi can any one help me nesting 3 formula with If and statements, I cant get passed #Value
View attachment 1481=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