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)