Convert temparature

[Hermes]

I would like to convert temparature.
I believe its the formula: CONVERT(286, "F", "C")

 

[PabblyMember3]

I would like to convert temparature.
I believe its the formula: CONVERT(286, "F", "C")

Yes, you are correct but there must be a cell value instead of static number ex: =CONVERT(D1, "C", "F") to get values corresponding to the values in specified columns.

 

[Hermes]

Yes, ofcourse. But can this be added to sheet formulas?

 

[PabblyMember3]

Yes, ofcourse. But can this be added to sheet formulas?

It is already there:

Just need to change the value and units, you can explore more about the supporting units here: https://support.google.com/docs/answer/6055540

 

[Fagun Shah]

It is already there:

View attachment 1156

Just need to change the value and units, you can explore more about the supporting units here: https://support.google.com/docs/answer/6055540

Doesn't work -

 

[Hermes]

It was not F but K, and I searched for the formula and solved it that way.