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.