Page 1 of 1
Excel Formula Error
Posted: 04 Jan 2013, 13:34
by Koko_Lion
Any assistance would much appreciated.
-To start, I bombed my laptop, installed Win 8 64bit and all updates to date.
-Installed Micro Office Pro Plus 2010 and all updates to date.
Now when I do a basic formula that I have always used previously eg:
The darn thing says "The Formula You Typed Contains An Error".
I checked my regional settings. Any other ways I can write this formula perhaps?
Shots!
Re: Excel Formula Error
Posted: 04 Jan 2013, 16:56
by Tribble
What language / regional settings do you have? Perhaps it is expecting the comma as a decimal?
Strike the above - did not see that you had checked it.
Can you email me the file? See if it is system specific or file specific?.
Re: Excel Formula Error
Posted: 04 Jan 2013, 19:44
by KALSTER
Try using brackets (a1)*(1.14)?
Re: Excel Formula Error
Posted: 04 Jan 2013, 20:04
by Tribble
He could try that but it should work exactly as he has it. We need to fix his problem but I have not heard of such a problem as this.
You can also try =A1*0.14+A1 - I still get the feeling that the problem is the decimal for some reason.
=A1*14%+A1 (if this works then it is definitely your decimal point)
Re: Excel Formula Error
Posted: 04 Jan 2013, 21:50
by StarBound
=+A1*1.14
Re: Excel Formula Error
Posted: 05 Jan 2013, 13:23
by Tribble
Where is that lion? Asks for help and then vanishes!
I want to know what his progress is
Re: Excel Formula Error
Posted: 07 Jan 2013, 13:22
by Koko_Lion
Hay! Sorry, been soo flippen busy.
I feel I deserve a slap. Decimal was set to comma in regional settings. Not sure how I missed that, too much beer over new years me thinks!
Re: Excel Formula Error
Posted: 07 Jan 2013, 17:11
by StarBound
, , , , , chameleon!
Re: Excel Formula Error
Posted: 08 Jan 2013, 11:38
by Tribble
Koko_Lion wrote:Hay! Sorry, been soo flippen busy.
I feel I deserve a slap. Decimal was set to comma in regional settings. Not sure how I missed that, too much beer over new years me thinks!
Phew - so glad to know I wasn't losing my mind. That was the only reason I could think of.
Glad you got it sorted.