How to convert Celcius to Fahrenheit

[system]

Hi Friends,

In BOXI R2 My scenario -

I have 4 columns - Number, Name, Temperature, Temperature Unit.

Tempefrature - Contains the measured value of temperature in Celcius and Fahrenheit.
Temperature units - Shows the units of the temperature measured.
now I need to convert the entire temperature column with temperature values to Celcuis. I tried ‘IF statement’ but didnot work.

Please help.

• Karthik

---

karthikgpks (BOB member since 2016-06-15)

[system]

Welcome to B:bob:B!

@karthikgpks

I tried ‘IF statement’ but didnot work.

Can you post what you tried?

---

Marek Chladny (BOB member since 2003-11-27)

[MarkP]

Wouldn’t it be something simple, like this:

=If([Units]="F";([Temp]-32)/1.8;[Temp])

[system]

Wow… Simple and easy… It really works… But still the values are not meeting exactly… I will take care that…

Thank you sooo much bro

Thank you All…

---

karthikgpks (BOB member since 2016-06-15)

[system]

Try using

(([Temp]-32)*5)/9

For the actual conversion part of the If statement by Mark, then format the result to whatever number of decimal places you require.

---

hueysantiago (BOB member since 2015-08-03)

[system]

@karthikgpks

But still the values are not meeting exactly…

I’m really curious why your values aren’t exact. It’s a pretty standard formula

---

joepeters (BOB member since 2002-08-29)

[MarkP]

@joepeters

@karthikgpks

But still the values are not meeting exactly…

I’m really curious why your values aren’t exact. It’s a pretty standard formula

Indeed.

I always test with
-40 to -40
0 to 32
100 to 212