A few days ago
Anonymous

In Microsoft Excel, how do I make a formula for converting Fahrenheit to Celsius and for using percentage?

In Microsoft Excel, how do I make a formula for converting Fahrenheit to Celsius and for using percentage?

Top 3 Answers
A few days ago
unknown friend

Favorite Answer

If you are entering it in as Fahrenheit you can put the formula in another column to convert it but it can not be done without a place to start so you need to do it in 2 columns. Your first column can however be in a different tab or file if you want to link them.

To convert from Fahrenheit to Celsius the conversion is: 1 celsius is equal to 33.80 fahrenheit or 1 fahrenheit is equal to -17.22 celsius

After you convert it with the formula you need to format the cell or column to percentage.

Once you have your formula working you can copy it to use elsewhere, if you copy it without the $ signs it will change to where it is pasted. If you put the $ into the formula it will be what is referred to as an absolute formula. Which basically means it will always use the cell you have the $ signs on and won’t move.

For ex. $a$1 * a2 will always use a1 and the a2 part will change to where you paste it. This is a method of putting the actual number you want to use to convert with in only once and allow it to change as you need it to elsewhere.

I hope this helps you.

1

A few days ago
shanaichie
F=32+9/5xC

C=(F-32)x5/9

1

6 years ago
cs
The Best Answer is WRONG. 16 Degrees C is NOT 540 Degrees F. ( 16 x 33 = 540 ). C to F is not a linear scale. The answer by shanaichie is correct as is using the Convert function in Excel. =CONVERT(16, “C”, “F”) (to convert 16 degrees C to F.
0