Can someone please take a look at this formula and help me figure out what is wrong or maybe a better way to accomplish this? Thanks.

=IF(AND(D13<$A$5, Recruitment_Package!$I$9={"In Bank Footprint"}), (D13*$B$5)/10000, (D13*$D$5)/10000,

IF(AND(D13<$A$6, Recruitment_Package!$I$9={"In Bank Footprint"}), (D13*$B$6)/10000, (D13*$D$6)/10000,

IF(AND(D13<$A$5, Recruitment_Package!$I$9={"In Bank Footprint"}),(D13*$B$7)/10000, (D13*$D$7)/10000,

IF(AND(D13<$A$8, Recruitment_Package!$I$9={"In Bank Footprint"}),(D13*$D$8)/10000,(D13*$D$8)/10000,

IF(AND(D13<$A$9,Recruitment_Package!$I$9={"In Bank Footprint"}),(D13*$B$9)/10000, (D13*$D$9)/10000 )))))

To explain what I'm trying to do:

I have a list of values in A5, A6, A7, A8, and A9(500,001 750,001 1,000,001 1,500,001 and>1,500,001)

I want to look at the number in D13 and see if it is < those value and keep looking until it falls in one of those categories.

There are also the condition that if a drop down is selected "In Bank Footprint" then it will calculate D13*B5/1000, but if not then calculate D13*D5/10000 and so on. Hope that helps and makes sense.