slab rate

[araugustine]

Hi,

I have a slab based benefit as below.

slab (up to) Rs Payout

1000 1

2000 2

5000 3

> 4

How do I write a formula in excel to pick up the correct benefit as per the slab above?

thx and rgds

 

[Hui]

I would add a single line to the top of your data being:

0 1

and change the > to 1000000 or some other big number

and then assuming your data is in A1:B5

use a simple Index/Match combo


=INDEX(A1:B5,MATCH(C1,A1:A5,1)+1,2)

Where your lookup valuen is in C1

 

[araugustine]

Works, great,thanks a ton