Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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.. |