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

"I need help please" wrote:

I had a previous post with a few questions. Most of them were answered.
But, I'm still having trouble.

Here's what I have in detail:

In 'Module1'

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

(I then hit save, exit VBE, save workbook)
types in =comission(A1)

I get #NAME? error still...

Thanks in advance for your help.