Wages Caluulation

[manoj1984]

i have 4 slabs for incentives like....

1 to 24 days = 0
25 to 26 days = 250
27 to 28 days = 500
29 to 31 days = 1000

every month depending upon the number of days worked by the person, automatically the incentive should add up with his wages.... pls can any one suggest me a formula for the same...

 

[gnrboyd]

I would create a table and use the VLOOKUP formula. (In this case you could use the LOOKUP but but the VLOOKUP has more capability so I never use the LOOKUP) You can search VLOOKUP in your Excel help file for more details on how it works. Here is an example:

Excel 2002
	A	B	C	D	E
1	Number of Days	26		Wage	250
2
3
4	Days	Wage
5	0	0
6	25	250
7	27	500
8	29	1000
Sheet1

Cell Formulas
Range	Formula
E1	=VLOOKUP($B$1,$A$5:$B$8,2)