[access-uk] Re: excel problem
- From: "Mark Threadgold" <m.j.threadgold@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Tue, 4 Oct 2011 11:43:03 +0100
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
Other related posts:
