How to test multiple conditions?

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
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?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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
ABCDEF
1SPHBonus/HrHoursSPHBonus
211.5517.5
321.758552
433.54636
5447545.5
656.57.5430
769108120
8710.56763
9812
10913.5
11
Sheet1


Hope that helps,

Paddy
 

Forum statistics

Threads
1,181,929
Messages
5,932,843
Members
436,865
Latest member
JHusk

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top