Syntax for a UDF

[Althas]

Hello all

I have a formula I use a lot to calculate a rate of National Insurance (in UK)

= SUMPRODUCT(--(F10>{7605;40040;42475}),(F10-{7605;40040;42475}),{0.104;0.034;0}))

What I want to do is have this as a UDF (say called NI) and of course the F10 in my formula above to be a definable cell reference (=ni(F10)) kind of thing

Is this possible? I can not seem to work it out

Thanks

[JosephP]

for instance

Please Login or Register  to view this content.

usage
=calcNI(F10)

[Althas]

Well that explains why it did not work for me, lol, what I was doing looks NOTHING like that

Thank you so much JosephP