You can have different incentive slabs like 0-25000,25000-40000,40000 and above
A1 = total amount

=LOOKUP(A1,{0,25001,40001},{0,1000,1500})

If this post helps click Yes
---------------
Jacob Skaria


" wrote:

Hi all,

I'm using Excel 2007. I would like to seek help regarding conditional
formatting.

What I would like to do is to create conditional formatting to show an
increase/decrease/equal arrow if the cell is greater/less than/equal
to the cell beside it. For example, if cell A2 is greater than A1, an
up arrow will appear in A2. And if cell A3 is less than A2, a down
arrow will show in A3.

Excel does not allow me to use relative cell referencing for
conditional formatting. So currently i have to do conditional
formatting manually for every cell. I have a few hundred rows and
columns. Is there a way I would be able to create a conditional
formatting so that can be applied to all the cells?

Thanks in advance.