Convert temparature

Status: Closed · Asked by Hermes on · 0 views

Hermes — Question ·

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

Best regards,
[EMAIL='[email hidden]']Hermes[/EMAIL]
Connect with me on LinkedIn
PabblyMember3 — Reply ·
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 — Reply ·

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

Best regards,
[EMAIL='[email hidden]']Hermes[/EMAIL]
Connect with me on LinkedIn
PabblyMember3 — Reply ·
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

Hermes — Reply ·

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

Attachments

screenshot-connect.pabbly.com-2021.05.28-10_42_47.png
Best regards,
[EMAIL='[email hidden]']Hermes[/EMAIL]
Connect with me on LinkedIn

Back to all forum threads · Log in to reply