Simple user defined function

[Subs]

Hi Please can anyone help
I have created a Function CtoF(Centigrade)
CtoF = Centigrade * 9 / 5 + 32

in theVB sheet1 code

I have then placed the function = CtoF (A2) in the worksheet cell B2

A2 contains a number, the function in Cell B2 should convert the number in
A2 to degrees Farenheit but it only gives me an error #NAME? I have the
correct addins and checked the names of functions but nothing works please
someone help.

 

[Frank Kabel]

Hi
there have you stored this UDF. It has to go into a standard module

 

[Inbar]

What exactly do you have in A2?
This worked fine for me...

 

[Dave Peterson]

You may want to use a function built-in to excel:

=CONVERT(A1,"C","F")

(well, unless this was a learning exercise???)