| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a Formula
I need to put a convertor from Fahrenheit to Celsius. I need to create the
formula to do it, but I'm not sure how. I have the tempeture on F on cell B5 and I need to put the conversion to C on C5. The formula is (F-32)*5/9=C How I insert that formula in the correct cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a Formula
Inside cell C%:
=Round((B2-32)*5/9, 1) That will round the response to 1 decimal. If you want you can change that number. It is the one to the right of the ")". HTH Thanks, Roger "Andrea" wrote: I need to put a convertor from Fahrenheit to Celsius. I need to create the formula to do it, but I'm not sure how. I have the tempeture on F on cell B5 and I need to put the conversion to C on C5. The formula is (F-32)*5/9=C How I insert that formula in the correct cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a Formula
Click C5
Type =(B5-32)*(5/9) Press the Enter key done -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Andrea" wrote in message ... I need to put a convertor from Fahrenheit to Celsius. I need to create the formula to do it, but I'm not sure how. I have the tempeture on F on cell B5 and I need to put the conversion to C on C5. The formula is (F-32)*5/9=C How I insert that formula in the correct cell? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a Formula
Bye a book on Excel? You might need it. If you intend to do anything with
Excel. Tyro "Andrea" wrote in message ... I need to put a convertor from Fahrenheit to Celsius. I need to create the formula to do it, but I'm not sure how. I have the tempeture on F on cell B5 and I need to put the conversion to C on C5. The formula is (F-32)*5/9=C How I insert that formula in the correct cell? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a Formula
Hi Andrea,
You can also use the convert function Put this in C5 =CONVERT(B5,"F","C") Check out the help file for the full range of conversions, it's very extensive. HTH Martin "Andrea" wrote in message ... I need to put a convertor from Fahrenheit to Celsius. I need to create the formula to do it, but I'm not sure how. I have the tempeture on F on cell B5 and I need to put the conversion to C on C5. The formula is (F-32)*5/9=C How I insert that formula in the correct cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Formula | Excel Discussion (Misc queries) | |||
| creating formula help | Excel Worksheet Functions | |||
| Creating a formula | Excel Worksheet Functions | |||
| help creating a formula using IF and AND | Excel Worksheet Functions | |||
| Help in creating a formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
