[access-uk] Re: excel problem
- From: "Brian Cairnie" <info@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Tue, 4 Oct 2011 13:07:12 +0100
Hi Mark and others,
You don't need the =sum at the beginning as you are not summing a row or
column, all you need is: -
=(F-32)*5/9)
Where F is the value in degrees Centigrade.
Hope this helps.
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
Mark Threadgold
Sent: 04 October 2011 13:03
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
** 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:
