-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help with formula for simple payroll
[h=2]Help with formula for simple payroll[/h]
<tbody>
</tbody>
hello
so i need a formula to say if my salary is 600 then use ee b3 also multiply ans by d1
ee and er are deductions from employee and employer
likewise if my salary would have fallen into any of the other ranges the formula would have to encompass this
ie
if my salary was 220 then use b1 multiply by di but if my salary was 341 then use b2 multiply by b2 and son on
| weekly salary | ee | er | weeks | salary |
| 200-339.99 | 11.9 | 23.8 | 4 | |
| 340-449.99 | 17.4 | 34.8 | ||
| 450-609.99 | 23.3 | 46.6 | ||
| 610-759.99 | 30.1 | 60.2 |
<tbody>
</tbody>
hello
so i need a formula to say if my salary is 600 then use ee b3 also multiply ans by d1
ee and er are deductions from employee and employer
likewise if my salary would have fallen into any of the other ranges the formula would have to encompass this
ie
if my salary was 220 then use b1 multiply by di but if my salary was 341 then use b2 multiply by b2 and son on
Upvote
0
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,364
- Office Version
- 365
- Platform
- MacOS
can you lay the table out differently
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
then use
=VLOOKUP(E3,A2:C7,2,TRUE)
| weekly salary | ee | er | weeks | salary | |
| 0 | |||||
| 200 | 11.9 | 23.8 | 4 | 340 | 17.4 |
| 340 | 17.4 | 34.8 | |||
| 450 | 23.3 | 46.6 | |||
| 610 | 30.1 | 60.2 | |||
| 760 |
<colgroup><col><col span="5"></colgroup><tbody>
</tbody>
then use
=VLOOKUP(E3,A2:C7,2,TRUE)
Upvote
0
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,764
- Office Version
- 365
- Platform
- Windows
@eabidh
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).
I have merged both threads.
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).
I have merged both threads.
Upvote
0
jtakw
Well-known Member
- Joined
- Jun 29, 2014
- Messages
- 7,245
- Office Version
- 2016
- Platform
- Windows
You didn't answer my question regarding Lower and Upper limits.
And you haven't really answered my question regarding "er" Column, I'm assuming it's Not being used in the formula:
And you haven't really answered my question regarding "er" Column, I'm assuming it's Not being used in the formula:
| Book1 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Salary from | to | ee | er | weeks | salary | Result | ||
| 2 | 0 | 199.99 | 4 | 600 | 93.2 | ||||
| 3 | 200 | 339.99 | 11.9 | 23.8 | |||||
| 4 | 340 | 449.99 | 17.4 | 34.8 | |||||
| 5 | 450 | 609.99 | 23.3 | 46.6 | |||||
| 6 | 610 | 759.99 | 30.1 | 60.2 | |||||
Sheet418 | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G2 | =LOOKUP(F2,A2:A6,C2:C6)*E2 | |
Last edited:
Upvote
0
jtakw
Well-known Member
- Joined
- Jun 29, 2014
- Messages
- 7,245
- Office Version
- 2016
- Platform
- Windows
Got your PM, eabidh
This is a public forum, you should post your question in a New Thread rather than asking questions in PM and try to get answers thru private eMail.
You would get much quicker and more responses that way also.
This is a public forum, you should post your question in a New Thread rather than asking questions in PM and try to get answers thru private eMail.
You would get much quicker and more responses that way also.
Upvote
0
