Hi I Need,

Your function works for me.

Is it perhaps possible that, whilst Commision only has a
single m, in your function, in the worksheet it entered with
the normal double m.


---
Regards,
Norman


"I need help please" wrote in
message ...
Sorry - that was a typo in the post - I used copy & paste for this one!

Public Function Comission(MyNum)
Comission = MyNum * 0.6
End Function

and the (MyNum As WHAT) didn't seem to work either