Hey all, I am trying to get a list of if statements to determine a shipping charge for me. Can anyone identify why I keep getting the "too few arguments" return?
=IF(AND(B4=AD3),P4*0.032,P4*.02,IF(AND(B4=AD4),P4*.03,P4*.02,IF(AND(b4=AD5),P4*.03,P4*.02,IF(and(b4=AD6),P4*.025,P4*.02))))
If it matches the true statement it should return p*the number I've entered. If it doesn't meet any of the 4 criteria I would like it to multiple by .02.
Thanks.
Mack
Bookmarks