[stealth]
March 30th, 2001, 01:53 PM
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.
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.