please help in excel functions.
 

Suppose, i have 3 incentive slabs

No.of sale incentive slab

1-10 no.of sale*8
11-20 no.of sale*10
21 and above no. of sale*15

What formula i have to insert in the incentive column , so i will get the
incentive of every salesman if i fill only the no. of sale in the column left
to incentive slab column ?If this works i will be able to save a lot of time
and energy so please help and explain in details with examples.

--
With Thanks
Regards

Rajesh Chandra

please help in excel functions.
 

I'm confused. You have reposted this question when two working answers were
clearly available to you before you did so (and since then, a third answer
was posted). Why? Did you not check your previous posting?

Rick


"Rajesh Chandra" wrote in message
...
Suppose, i have 3 incentive slabs

No.of sale incentive slab

1-10 no.of sale*8
11-20 no.of sale*10
21 and above no. of sale*15

What formula i have to insert in the incentive column , so i will get the
incentive of every salesman if i fill only the no. of sale in the column
left
to incentive slab column ?If this works i will be able to save a lot of
time
and energy so please help and explain in details with examples.

--
With Thanks
Regards

Rajesh Chandra

please help in excel functions.
 

Arrange your table this way

A B C D
No.of sales table incentive No.of sales incentive slab
0 1 0 0
1 8 1 8
11 10 10 80
21 15 11 110
20 200
21 315
22 330

The formula in D2 is
=C2*VLOOKUP(C2,$A$2:$B$5,2)
Drag down as required!

Regards,
Stefi


€žRajesh Chandra€� ezt Ã*rta:

Suppose, i have 3 incentive slabs

No.of sale incentive slab

1-10 no.of sale*8
11-20 no.of sale*10
21 and above no. of sale*15

What formula i have to insert in the incentive column , so i will get the
incentive of every salesman if i fill only the no. of sale in the column left
to incentive slab column ?If this works i will be able to save a lot of time
and energy so please help and explain in details with examples.

--
With Thanks
Regards

Rajesh Chandra