Nested IF, AND Problem

Hi All,

Im having a problem with the below:

=IF(AND(AA1="United Kingdom",P5>50),"DHL","RM",IF(AND(AA1<>"United Kingdom",P1>10),"DPD","RM"))

Am i missing something very obvious as i keep getiing "You've entered to many arguements for this function"

Im stumped!!

Many thanks

Jamie

PS. Im using Excel 2007 not 2003

Hi Jamie,

I suspect you may want

Please Login or Register  to view this content.

but can't be certain unless I understand what the rule is. Your original formula did indeed have an extra argument assuming that the second IF test is correct.

If not explain what you're trying to do, with a couple or three examples.

Regards