[RESOLVED] Excel 97

[[stealth]]

I am creating pay slips on excel for my dads shop. if you dont already know this is how National Insurance is worked out,

It is 10% of wages OVER £76/week, so this is the formula im using

B2= employees weekly earnings

=IF(B2>76,B2-76/100*10,0)

so if B2 =£100 it should calculate that national insurance is 2.4, it does that on a calculator. but excel says its 92.4

quite strange, someone help me out, there must be another way of doing it.

[Sowulo]

Originally posted by [=- STEALTH -=]:
I am creating pay slips on excel for my dads shop. if you dont already know this is how National Insurance is worked out,

It is 10% of wages OVER £76/week, so this is the formula im using

B2= employees weekly earnings

=IF(B2>76,B2-76/100*10,0)

so if B2 =£100 it should calculate that national insurance is 2.4, it does that on a calculator. but excel says its 92.4

quite strange, someone help me out, there must be another way of doing it.

=IF(B2>76,(B2-76)/100*10,0)

Remember your basic hierarchy of operands: Multiplication and Division first.....

[[stealth]]

cheers, hope it works