Formulae to calculate the incentive in slab basis for targets achieved,.

[Gopi Chand]

I want the formula in single cell covering all the four slabs.

Currently i am using in as below.

Slabs	PO Value	Min Closure	Incentive Amt
0	20000	2	0
1	35000	3	3000
2	45000	2	2000
3	55000	2	3000
4	90000	3	5400

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

=

IF(AND(#REF!>=15000,#REF!<=25000,A8>=3),A8*500,IF(AND(#REF!>25000,#REF!<=45000,A8>=2),A8*1000,IF(AND(#REF!>45000,#REF!<=60000,A8>=2),A8*1500,IF(AND(#REF!>60000,A8>=2),A8*1800,0))))

<tbody>
</tbody>

 

[Oeldere]

Don't understand the question.

explain more, and what would be the desired result.