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

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

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,144,449
Messages
5,724,414
Members
422,552
Latest member
Ajit Kumar_1982

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