Hi

F = 1.8C + 32

C = (F-32)/1.8

This function,

Function F1(C)
F1 = 1.8C + 32
End Function

- will convert Celsius to Fahrenheit.

Regards

Andrew Bourke

Sam wrote:
I am trying to create a custom function in Excel XP to automatically convert
temperatures from Farenheit to Celsius and vice versa.