| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| How do you set up a formula ( as for a check book.) | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
