I am trying to make a multiple critera statment and it keep returning a FALSE value. Basically I need to to look at two cells and say If E4=2.375 and F4=14, then multiply D4 by AB41, but if E4=2.375 and F4=12, then multiply D4 by AB40, etc etc eventually I will add in the statement if E4=2.875 and F4=14... and so on. Please help!
=IF(AND(E4=2.375,F4=14),D4*AB41,IF(AND(E4=2.375,F4=12),D4*AB40,IF(AND(E4=2.375,F4=11),D4*AB39,IF(AND(E4=2.375,F4=10),D4*AB38))))
=IF(AND(E4=2.375,F4=14),D4*AB41,IF(AND(E4=2.375,F4=12),D4*AB40,IF(AND(E4=2.375,F4=11),D4*AB39,IF(AND(E4=2.375,F4=10),D4*AB38))))