How to test multiple conditions?

[imported_unknown]

Hello,
I need small help:This is the problem:
In my work place, Depending on Sale per Hour (SPH), Bonus will be given.The followong is pre defined as follows:
SPH Bonus/Hr
1 1.50
2 1.75
3 3.50
4 4.00
5 6.50
6 9.00
7 10.50
8 12.00
9 13.50

in Excel,
COLUMN A is Total working HRs (TWHR)
COLUMN B is showing (SPH)
COLUMN C is to be calculated as per the bonus structure above.
How to do this? I don't know Excel programmimg very much. Can you please send me the solution?

 

[PaddyD]

Hi - welcome to the board!

Looks like vlookup() is the function you need - check it out in the help files...

I have set up an example based on the data you provided:

Book2
	A	B	C	D	E	F
1	SPH	Bonus/Hr		Hours	SPH	Bonus
2	1	1.5		5	1	7.5
3	2	1.75		8	5	52
4	3	3.5		4	6	36
5	4	4		7	5	45.5
6	5	6.5		7.5	4	30
7	6	9		10	8	120
8	7	10.5		6	7	63
9	8	12
10	9	13.5
11
Sheet1

Hope that helps,

Paddy