Printable View
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)Quote:
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.
Remember your basic hierarchy of operands: Multiplication and Division first.....
cheers, hope it works