Nesting If with And Functions Help Please

pleased2help

New member
Joined
Jun 27, 2013
Messages
28
Reaction score
0
Points
0
Hi can any one help me nesting 3 formula with If and statements, I cant get passed #Value
Example.jpg
 
Stumbled on the answer

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
 
Back
Top