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...