[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

Other related posts: