[access-uk] Re: excel problem
- From: "David W Wood \(G3YXX\)" <david.g3yxx@xxxxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Tue, 4 Oct 2011 13:31:48 +0100
In an older version of Excel there was a conversion facility. Does this exist
in later versions?
David W Wood
Ham call - G3YXX
FOC # - 1685
Licensed - 1969
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of
Mark Threadgold
Sent: Tuesday, October 04, 2011 1:03 PM
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: excel problem
Try the following formula to convert Fahrenheit to Centigrade
=sum((F-32)*5/9)
In place of the F in the formula, put the Fahrenheit figure you want to
convert to Centigrade.
Hope it helps.
Mark Threadgold
Of all the things I have ever lost, The one I miss most is my mind...
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of
Joe Hunter
Sent: 04 October 2011 12:55
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: excel problem
Hello Mark please explain above as they confuse me totally. Joe
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of
Mark Threadgold
Sent: 04 October 2011 11:43
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: excel problem
To convert from Centigrade to Fahrenheit
F=(C*9/5)+32
To convert from Fahrenheit to Centigrade
C=(F-32)*5/9
Your formula ismssing the brackets that make the subtraction before it is
multiplied.
Mark Threadgold
Of all the things I have ever lost, the one I miss most is my mind.
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of
Joe Hunter
Sent: 04 October 2011 11:31
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] excel problem
I am trying to convert faronheight to centre grade and vice versa. I am ok
with the formular =(100/5*9+32 and that comes out at 212 f. When I f to c
=(212-32/9*5) comes out nonsence can anyone help with this please.
. It works with the calculator but not in my sheet witch is 2203.
With thanks Joe.
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.914 / Virus Database: 271.1.1/3936 - Release Date: 10/03/11
19:34:00
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
--
I am using the free version of SPAMfighter.
We are a community of 7 million users fighting spam.
SPAMfighter has removed 1918 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
