 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / January 2007A 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? 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.  SignatureY > 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 [quoted text clipped - 10 lines] > on the street. > Can anyone help? Pleeeeeease? 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 > Ready? > [quoted text clipped - 17 lines] > > on the street. > > Can anyone help? Pleeeeeease? You bet. I probably learned it here! SignatureY > 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 [quoted text clipped - 23 lines] > > > on the street. > > > Can anyone help? Pleeeeeease? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.