| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert from Fahrenheit to Centigrade
I am trying to convert several columns of fahrenheit temperatures to
centigrade but cannot get the necessary formula. Any help appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert from Fahrenheit to Centigrade
Keith
If the F temp is in column A in B1 enter =(((A1-32)/9)*5) and copy down -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Keith Johnson" <Keith wrote in message ... I am trying to convert several columns of fahrenheit temperatures to centigrade but cannot get the necessary formula. Any help appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert from Fahrenheit to Centigrade
Nick,
Is your formula any different from =(A1-32)/9*5 Is there a benefit to be had from the additional parantheses; or is there a 'best practice' reason; or is it just personal preference? I'm always on the lookout to improve my understanding. Regards Len "Nick Hodge" wrote in message ... Keith If the F temp is in column A in B1 enter =(((A1-32)/9)*5) and copy down -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Keith Johnson" <Keith wrote in message ... I am trying to convert several columns of fahrenheit temperatures to centigrade but cannot get the necessary formula. Any help appreciated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert from Fahrenheit to Centigrade
Len
As it happens no as the * and / have the same precedence. I suppose it is personal preference. I always break the formulae down to it's component parts in my head and add parenthesis to match that 'view' I might try and argue that it is better practice too, but I'd be on thin ice as I don't fully understand the way Excel handles it, where if you make it explicit Excel will find it easier/quicker to parse. I always use too many commas in writing too ;-) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Len B" <gonehome(atoptusnet:com:au) wrote in message ... Nick, Is your formula any different from =(A1-32)/9*5 Is there a benefit to be had from the additional parantheses; or is there a 'best practice' reason; or is it just personal preference? I'm always on the lookout to improve my understanding. Regards Len "Nick Hodge" wrote in message ... Keith If the F temp is in column A in B1 enter =(((A1-32)/9)*5) and copy down -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Keith Johnson" <Keith wrote in message ... I am trying to convert several columns of fahrenheit temperatures to centigrade but cannot get the necessary formula. Any help appreciated. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert from Fahrenheit to Centigrade
Len
I should have said...have the same precedence and so will be evaluated in order -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Nick Hodge" wrote in message ... Len As it happens no as the * and / have the same precedence. I suppose it is personal preference. I always break the formulae down to it's component parts in my head and add parenthesis to match that 'view' I might try and argue that it is better practice too, but I'd be on thin ice as I don't fully understand the way Excel handles it, where if you make it explicit Excel will find it easier/quicker to parse. I always use too many commas in writing too ;-) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Len B" <gonehome(atoptusnet:com:au) wrote in message ... Nick, Is your formula any different from =(A1-32)/9*5 Is there a benefit to be had from the additional parantheses; or is there a 'best practice' reason; or is it just personal preference? I'm always on the lookout to improve my understanding. Regards Len "Nick Hodge" wrote in message ... Keith If the F temp is in column A in B1 enter =(((A1-32)/9)*5) and copy down -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Keith Johnson" <Keith wrote in message ... I am trying to convert several columns of fahrenheit temperatures to centigrade but cannot get the necessary formula. Any help appreciated. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert from Fahrenheit to Centigrade
Hi Nick
I always use too many commas in writing too ;-) Obviously a fan of Eats Shoots & Leaves<vbg -- Regards Roger Govier "Nick Hodge" wrote in message ... Len As it happens no as the * and / have the same precedence. I suppose it is personal preference. I always break the formulae down to it's component parts in my head and add parenthesis to match that 'view' I might try and argue that it is better practice too, but I'd be on thin ice as I don't fully understand the way Excel handles it, where if you make it explicit Excel will find it easier/quicker to parse. I always use too many commas in writing too ;-) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Len B" <gonehome(atoptusnet:com:au) wrote in message ... Nick, Is your formula any different from =(A1-32)/9*5 Is there a benefit to be had from the additional parantheses; or is there a 'best practice' reason; or is it just personal preference? I'm always on the lookout to improve my understanding. Regards Len "Nick Hodge" wrote in message ... Keith If the F temp is in column A in B1 enter =(((A1-32)/9)*5) and copy down -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Keith Johnson" <Keith wrote in message ... I am trying to convert several columns of fahrenheit temperatures to centigrade but cannot get the necessary formula. Any help appreciated. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert from Fahrenheit to Centigrade
Have you seen this one?
that that is is that that is not is not that that will be will be or woman without her man is nothing .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. That, that is, is. That, that is not, is not. That, that will be, will be. Woman, without her man, is nothing. Woman, without her, man is nothing. or Woman without Herman, is nothing. (from a guy named Herman!) Roger Govier wrote: Hi Nick I always use too many commas in writing too ;-) Obviously a fan of Eats Shoots & Leaves<vbg -- Regards Roger Govier <<snipped |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert from Fahrenheit to Centigrade
Thanks Nick,
I, too, use commas. See. But I don't plead guilty to using too many '-) I thought it may have been a "it helps my head" thing but there may be something to your quicker/easier theory. Thanks for your humour too. Len "Nick Hodge" wrote in message ... Len As it happens no as the * and / have the same precedence. I suppose it is personal preference. I always break the formulae down to it's component parts in my head and add parenthesis to match that 'view' I might try and argue that it is better practice too, but I'd be on thin ice as I don't fully understand the way Excel handles it, where if you make it explicit Excel will find it easier/quicker to parse. I always use too many commas in writing too ;-) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Len B" <gonehome(atoptusnet:com:au) wrote in message ... Nick, Is your formula any different from =(A1-32)/9*5 Is there a benefit to be had from the additional parantheses; or is there a 'best practice' reason; or is it just personal preference? I'm always on the lookout to improve my understanding. Regards Len "Nick Hodge" wrote in message ... Keith If the F temp is in column A in B1 enter =(((A1-32)/9)*5) and copy down -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Keith Johnson" <Keith wrote in message ... I am trying to convert several columns of fahrenheit temperatures to centigrade but cannot get the necessary formula. Any help appreciated. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert from Fahrenheit to Centigrade
Thanks for spelling humour correctly ;-)
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Len B" <gonehome(atoptusnet:com:au) wrote in message ... Thanks Nick, I, too, use commas. See. But I don't plead guilty to using too many '-) I thought it may have been a "it helps my head" thing but there may be something to your quicker/easier theory. Thanks for your humour too. Len "Nick Hodge" wrote in message ... Len As it happens no as the * and / have the same precedence. I suppose it is personal preference. I always break the formulae down to it's component parts in my head and add parenthesis to match that 'view' I might try and argue that it is better practice too, but I'd be on thin ice as I don't fully understand the way Excel handles it, where if you make it explicit Excel will find it easier/quicker to parse. I always use too many commas in writing too ;-) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Len B" <gonehome(atoptusnet:com:au) wrote in message ... Nick, Is your formula any different from =(A1-32)/9*5 Is there a benefit to be had from the additional parantheses; or is there a 'best practice' reason; or is it just personal preference? I'm always on the lookout to improve my understanding. Regards Len "Nick Hodge" wrote in message ... Keith If the F temp is in column A in B1 enter =(((A1-32)/9)*5) and copy down -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Keith Johnson" <Keith wrote in message ... I am trying to convert several columns of fahrenheit temperatures to centigrade but cannot get the necessary formula. Any help appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number to its letters ( convert "1" to "One" ) | Excel Discussion (Misc queries) | |||
| Convert displayed number to absolute value | Excel Discussion (Misc queries) | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Hybrid Mode
