Hi

I entered my first User Defined Function so I could use this formula "US2DEC" in excel.

I followed these instructions ...

Go to the Visual Basic editor (Alt + F11) and copy and paste the function below

Code:

Function US2DEC(US) as Double

If US < 0 Then
US2DEC = 1 / (US / (US -100))
Else
US2DEC = 1 / (100 / (US + 100))
End If

End Function

I used Alt+F11 to open the editor and Pasted all the code in the blank space that was just opened.
I closed the editor and saved the workbook as a macro enabled workbook (.xlsm extension).

However when I enter any information now I get ...

Ambiguous name detected: US2DEC

I can't get back to the module I created to delete it.

I was better off just to enter the formula manually.

Can anyone help please?