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)

52 lookers at this thread so far, but no answers? Anyone?

Gotta get all the taxes done & into the accountant b4 heading off to Europe soon .....

__________________
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)

I don't know if I quite understand what you are asking, and it doesn't sound like the most efficient way to do it but you can nest IF functions within other if functions. Alternatively you could consider using a count and a vlookup function looking at a table which would make it easy to adjust tax amounts as you need.

I did Google it b4 posting on here... tried "nesting" IF functions but it keeps coming back with errors . Didn't think it would be such a complicated issue as it has turned out.

__________________
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)

Might not help but it is any easier to just add another cell so on 5 day week you use cell A and 6 day week you use cell B?

Ill ask the girl at work tomorrow to have a look and see what she says anyway.

__________________
Bush chook enthusiast

While probably not the most efficient way, IF functions should have worked, maybe paste what you are trying to enter, see if someone can spot the error?

I think i know what you're asking, and should be able to write nested IF formula/function to do what you want, but it's late over here, I'll tackle it in the morning.

__________________
Signarape!

Copy and paste your formula so we can see, I know Bryno is really good at excel. If you email it to me I will take a look.

Your IF statement should go along the lines of:

Where A1 is the number of days worked. It isn't an efficient way but at the end of the day if you understand the sheet and it does what it needs to then it should be fine

Here is my (failed) attempt, where I21 is the Total Pay, and the following formula is input into I23, which is the Tax Withheld value:

=IF(I21=904.25,154,154,=IF(I21=753.54,103,103,=IF( I21=602.83,69,69,=IF(I21=452.12,44,44,=IF(I21=301. 42,14,14,=IF(I21=150.71,0,0))))))

Maybe I need to use OR formulae? I'm a bit if a noob at Excel .

__________________
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)

Try this:


=IF(I21=904.25,154,IF(I21=753.54,103,IF(I21=602.83 ,69,IF(I21=452.12,44,IF(I21=301.42,14,IF(I21=150.7 1,0,0))))))

Just review the numbers to make sure they are right. You were very close, you just replace the false statement with another IF function instead and don't use = other than at the beginning