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.