farmula

[arshadbhatti309]

i want to prepare a worksheet in which i need the formula for

example

people having salaries ranging from Rs. 10000 to 50000 and company decides to give incentive to the employees recieving salary less than 10000 @ 50%, less than 20000 @ 40%, less than 30000 @ 30% and more than 30000 @ 20%

please tell me the formula in excel sheet to calculate the amount of incentiv

 

[Craigjre]

I think I understand what you are looking for, assuming the amount will be entered into cell, say A1, you could set up an if function:

=IF(A1<10000,A1*0.5,IF(AND(A1>10000,A1<20000),A1*0.4,IF(AND(A1>20000,A1<30000),A1*0.3,IF(A1>30000,A1*0.2))))

Is this what you meant?

 

[anandvarma]

try this

Excel Workbook
	A	B	C	D	E
2	9999	14998.5		10000	50%
3	19999	27998.6		20000	40%
4	29999	38998.7		30000	30%
5	39999	47998.8		40000	20%
6	49999	59998.8		50000	20%
7	51000	51000
8
Sheet1