Excel Formula Error

Discussion and support for the Windows family of operating systems.
Post Reply
Koko_Lion
Registered User
Posts: 13227
Joined: 25 Feb 2008, 02:00
Location: Relaxing in the savannah...
Contact:

Excel Formula Error

Post 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:

Code: Select all

=A1*1.14
The darn thing says "The Formula You Typed Contains An Error". :evil:

I checked my regional settings. Any other ways I can write this formula perhaps?

Shots!
Image
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Excel Formula Error

Post 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?.
Image
KALSTER
Forum Moderator
Posts: 5439
Joined: 12 Oct 2008, 02:08

Re: Excel Formula Error

Post by KALSTER »

Try using brackets (a1)*(1.14)?
"It is the mark of an educated mind to be able to entertain a thought without accepting it." - Aristotle
Intel i5 2500; AsRock Z77 Extreme 4; Asus GTX580; 4x 2GB DDR3 1333; Intel 520 240GB SSD + 2x WD 3TB + 2TB Samsung; Samsung 22X DVD/RW; 23" LG W2343T-PF; Huntkey 700W
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Excel Formula Error

Post 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)
Image
StarBound
Registered Pervert
Posts: 6879
Joined: 30 Jul 2004, 02:00
Processor: Intel i7 4790k
Motherboard: MSI Z97 Gaming 7
Graphics card: MSI GTX780Ti Gaming
Memory: G.Skill Sniper 1866mhz 16GB
Location: The Greater Unknown
Contact:

Re: Excel Formula Error

Post by StarBound »

=+A1*1.14
My Steam Screenshots

I lived the dream ...then my PC died.
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Excel Formula Error

Post by Tribble »

Where is that lion? Asks for help and then vanishes! :P I want to know what his progress is
Image
Koko_Lion
Registered User
Posts: 13227
Joined: 25 Feb 2008, 02:00
Location: Relaxing in the savannah...
Contact:

Re: Excel Formula Error

Post 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! :oops:
Image
StarBound
Registered Pervert
Posts: 6879
Joined: 30 Jul 2004, 02:00
Processor: Intel i7 4790k
Motherboard: MSI Z97 Gaming 7
Graphics card: MSI GTX780Ti Gaming
Memory: G.Skill Sniper 1866mhz 16GB
Location: The Greater Unknown
Contact:

Re: Excel Formula Error

Post by StarBound »

, , , , , chameleon!
My Steam Screenshots

I lived the dream ...then my PC died.
User avatar
Tribble
Registered User
Posts: 88465
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Excel Formula Error

Post 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! :oops:
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.
Image
Post Reply