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