View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Len B Len B is offline
external usenet poster
 
Posts: 18
Default 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.