Using IF & AND command in conjunction
I have a sales incentive grid with tenure of loan on one axis & loan size on
another axis. For e.g., for a loan size between $6000 to $9999 at a tenor of
24 months, teh incentive payable is $24 whereas for a loan size between
$10000 to &19999 at a tenor of 36 months, the incentive payable is $65. There
are a total of 7 loan bands on one axis and 5 tenor bands on the other axis.
How do i create a formula so that excel picks the correct incentive amount
depending upon the loan amount and tenor combination.
Its so confusing. Pls help..
|