FORMULA FOR CELSIUS TO FAHRENHEIT
Question: Although I followed what was given, my answer displays #NAME?
This is what I did: Cell a1 is my input and cell b1 contains the formula:
=CONVERT(a1,"C","F")&"°F"
b1 returns #NAME?
Will you explain what I am doing incorrectly. Do the cells need to be
formatted in any manner?
Thanks.
"egun" wrote:
To get the degree sign, etc:
=CONVERT(A2,"C","F")&"°F"
|