[access-uk] Re: excel problem
- From: "Brian Cairnie" <info@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Tue, 4 Oct 2011 14:13:32 +0100
Hi David,
Had a very quick look in Excel and can't find any convertor function, but I'm
on my way out of the office so I'll have a proper look later.
Brian Cairnie
Cragside AccessABILITY Limited
Telephone: 0844 500 7091
Fax: 0844 500 7098
DotLine: 0844 500 7099
Skype: cragside_accessabilty
Email: info@xxxxxxxxxxxx
Web: www.cragside.com
P O Box 469, Sevenoaks, Kent, TN13 9JJ (Not for deliveries please)
-------------------------------------------------------------------------------------------------------------------------
This email and files transmitted with it are confidential and intended solely
for the use of the individual or entity to whom they are addressed. If you are
not the named recipient, or have received this in error, please notify Cragside
AccessABILITY Limited immediately by telephone and delete this email: do not
disclose the contents to any other person or copy or store the contents.
Whilst every reasonable precaution has been taken, Cragside AccessABILITY
Limited cannot accept liability for any damage which you sustain as a result of
software viruses that may be contained in or attached to this email.
THINK BEFORE YOU PRINT... THINK GREEN
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of
David W Wood (G3YXX)
Sent: 04 October 2011 13:32
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: excel problem
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
** 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:
