|
|
LinkBack | Thread Tools | Display Modes |
#1
|
||||
|
||||
Help with Excel based timesheet
Any Excel experts out there? I'll try to keep it brief...
I have a part time employee who works anything from 1 to 6 days with me. I use a freebie Excel based timesheet which I snagged off the Net, and have managed to personalise it for the most part. The only prob I can't solve goes like this: Each work day is always the same number of hours, meaning there are only 6 possible weekly incomes depending on number of days worked. This also means there are only 6 possible amounts of tax withheld. Under the Total Pay cell I have added two further descriptions, being Tax Withheld and Nett Pay. I've got the Nett Pay cell function working, but I can't work out the formula for the tax withheld cell value unless I only put in a single calculation argument. Is there a way to put in multiple arguments so that, eg, 6 days pay=$A tax withheld, 5 days pay=$B tax withheld etc? Hope that explains it..... thanks in advance for any solution.
__________________
MY99 WRX sedan WRC blue Sold :( MY99 WRX sedan Dark blue pearl :D MY97 Liberty Outback Ltd Wagon 1990 Mk3 Supra turbo fully rebuilt 7M-GTE (Older son) 1991 Celica GT4 (Younger son) |
Tags |
based, excel, timesheet |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Report: Peugeot developing compact crossover based on 208 hatch | rss.feed | General Subaru Discussion | 0 | 07-01-2012 12:00 AM |
Hyundai Excel 1997 $1500ono | mrclubspecevo4 | For Sale (Cars Only) | 0 | 17-12-2010 09:27 PM |
Microsoft Excel HELP | Wiiha | Non-WRX Discussion | 2 | 26-01-2008 08:27 AM |
MY2000 Excel Headlights | hybridgx | Wanted | 0 | 12-04-2007 08:41 PM |
Help with Microsoft Excel | ImPreSiV | Non-WRX Discussion | 5 | 08-03-2007 12:52 PM |