|
A Formula For A Wages Book
An apprentice employee pays different rates of Social Insurance depending on
his Gross Pay in any given week. If he earns less than ぎ300.00, he pays no SI. Between ぎ300.01 and ぎ450.00, he pays nothing on the first ぎ127.00 and 4% on the balance. From ぎ450.01up he pays 2% on the first ぎ127.00 and 6% on the balance. I need a formula I can enter that will recognise these criteria and do the calculations. I started the weekly Gross Pay in one column, say G9 and the second week G10 etc.. I'm just one week at Excell (2003) and trying to work out a formula for this is driving me mad. I've spent hours today and feel like throwing the PC out on the street. Can anyone help? Pleeeeeease? |
A Formula For A Wages Book
Ready?
=If(G9<=300,0,If(G9<=450,(0.04*(G9-127)),(2.54+(G9-127)*0.06))) That should do it. Copy it and paste it all the way down so that G9 becomes G10, G11, G12, etc. -- Y "Gatsby" wrote: An apprentice employee pays different rates of Social Insurance depending on his Gross Pay in any given week. If he earns less than ぎ300.00, he pays no SI. Between ぎ300.01 and ぎ450.00, he pays nothing on the first ぎ127.00 and 4% on the balance. From ぎ450.01up he pays 2% on the first ぎ127.00 and 6% on the balance. I need a formula I can enter that will recognise these criteria and do the calculations. I started the weekly Gross Pay in one column, say G9 and the second week G10 etc.. I'm just one week at Excell (2003) and trying to work out a formula for this is driving me mad. I've spent hours today and feel like throwing the PC out on the street. Can anyone help? Pleeeeeease? |
A Formula For A Wages Book
Yacbo, thanks a million! That has worked a treat. It was totally different to
how I was trying to do it. Where did you learn it? I looked up conditional formulas but couldn't find anything to help with my needs. Thanks for taking the time to answer; I really appreciate it. Gatsby "Yacbo" wrote: Ready? =If(G9<=300,0,If(G9<=450,(0.04*(G9-127)),(2.54+(G9-127)*0.06))) That should do it. Copy it and paste it all the way down so that G9 becomes G10, G11, G12, etc. -- Y "Gatsby" wrote: An apprentice employee pays different rates of Social Insurance depending on his Gross Pay in any given week. If he earns less than ぎ300.00, he pays no SI. Between ぎ300.01 and ぎ450.00, he pays nothing on the first ぎ127.00 and 4% on the balance. From ぎ450.01up he pays 2% on the first ぎ127.00 and 6% on the balance. I need a formula I can enter that will recognise these criteria and do the calculations. I started the weekly Gross Pay in one column, say G9 and the second week G10 etc.. I'm just one week at Excell (2003) and trying to work out a formula for this is driving me mad. I've spent hours today and feel like throwing the PC out on the street. Can anyone help? Pleeeeeease? |
A Formula For A Wages Book
You bet. I probably learned it here!
-- Y "Gatsby" wrote: Yacbo, thanks a million! That has worked a treat. It was totally different to how I was trying to do it. Where did you learn it? I looked up conditional formulas but couldn't find anything to help with my needs. Thanks for taking the time to answer; I really appreciate it. Gatsby "Yacbo" wrote: Ready? =If(G9<=300,0,If(G9<=450,(0.04*(G9-127)),(2.54+(G9-127)*0.06))) That should do it. Copy it and paste it all the way down so that G9 becomes G10, G11, G12, etc. -- Y "Gatsby" wrote: An apprentice employee pays different rates of Social Insurance depending on his Gross Pay in any given week. If he earns less than ぎ300.00, he pays no SI. Between ぎ300.01 and ぎ450.00, he pays nothing on the first ぎ127.00 and 4% on the balance. From ぎ450.01up he pays 2% on the first ぎ127.00 and 6% on the balance. I need a formula I can enter that will recognise these criteria and do the calculations. I started the weekly Gross Pay in one column, say G9 and the second week G10 etc.. I'm just one week at Excell (2003) and trying to work out a formula for this is driving me mad. I've spent hours today and feel like throwing the PC out on the street. Can anyone help? Pleeeeeease? |
| All times are GMT +1. The time now is 12:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com