I am trying to convert several columns of fahrenheit temperatures to
centigrade but cannot get the necessary formula. Any help appreciated.

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.

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.

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.

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.

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.

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.

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

Very good Dave.
No I hadn't seen it.

But if the that that that that referred to was this then that that would
be this.

--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
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

I got it!

I thought and thought but what I thought was not the thought I thought I
thought. If I could think another think, I'd write it down in pen and ink.

Roger Govier wrote:

Very good Dave.
No I hadn't seen it.

But if the that that that that referred to was this then that that would
be this.

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
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

--

Dave Peterson

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.

Considering where the thread started, perhaps we should end there before
the thoughts of other posters turn "frosty"<g

--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
I got it!

I thought and thought but what I thought was not the thought I thought
I
thought. If I could think another think, I'd write it down in pen and
ink.

Roger Govier wrote:

Very good Dave.
No I hadn't seen it.

But if the that that that that referred to was this then that that
would
be this.

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
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

--

Dave Peterson

Is there another way? Americans don't speak english. They just think they
do. You have reminded me of something I found amusing:
The questions below about Australia are from potential visitors. They were
posted on an Australian Tourism Website and the answers are the actual
responses by the website officials, who obviously have a sense of humour.

Q: Will I be able to speak English most places I go? (USA)

A: Yes, but you'll have to learn it first.

Q: Will I be able to see kangaroos in the street? (USA)

A: Depends how much you've been drinking.

Q: I want to walk from Perth to Sydney - can I follow the railroad tracks?
(Sweden)

A: Sure, it's only three thousand miles, take lots of water.

Q: Is it safe to run around in the bushes in Australia? (Sweden)

A: So it's true what they say about Swedes.

Q: Can you give me some information about hippo racing in Australia? ( USA)

A: A-Fri-ca is the big triangle shaped continent south of Europe.
Aus-tra-lia is that big island in the middle of the Pacific which does
not... Oh forget it. Sure, the hippo racing is every Tuesday night in Kings
Cross. Come naked.

Q: Which direction is North in Australia? (USA)

A: Face south and then turn 180 degrees. Contact us when you get here and
we'll send the rest of the directions.

Q: Can you send me the Vienna Boys' Choir schedule? (USA)

A: Aus-tri-a is that quaint little country bordering Ger-man-y, which
is...oh forget it. Sure, the Vienna Boys Choir plays every Tuesday night in
Kings Cross, straight after the hippo races. Come naked.

Q: Can I wear high heels in Australia? ( UK)

A: You are a British politician, right?

Q: Please send a list of all doctors in Australia who can dispense
rattlesnake serum. (USA)

A: Rattlesnakes live in A-meri-ca which is where YOU come from. All
Australian snakes are perfectly harmless, can be safely handled and make
good pets.

Q: I have a question about a famous animal in Australia, but I forget its
name. It's a kind of bear and lives in trees. (USA)

A: It's called a Drop Bear. They are so called because they drop out of Gum
trees and eat the brains of anyone walking underneath them. You can scare
them off by spraying yourself with human urine before you go out walking.

Q: Do you have perfume in Australia? (France)

A: No, WE don't stink.

Q: I have developed a new product that is the fountain of youth. Can you
tell me where I can sell it in Australia? (USA)

A: Anywhere significant numbers of Americans gather.

Q: Can you tell me the regions in Tasmania where the female population is
smaller than the male population? (Italy)

A: Yes, gay nightclubs.

Q: Do you celebrate Christmas in Australia? (France)

A: Only at Christmas.

"Nick Hodge" wrote in message
...
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.