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?

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.
--
Y


"Gatsby" wrote:

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?

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

"Yacbo" wrote:

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.
--
Y


"Gatsby" wrote:

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?

You bet. I probably learned it here!
--
Y


"Gatsby" wrote:

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

"Yacbo" wrote:

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.
--
Y


"Gatsby" wrote:

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?