Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-30-2009, 08:18 AM
Novice
 
Join Date: Jan 2009
Location: Southampton
Posts: 2
Florish is on a distinguished road
Unhappy Why wont my simple formulae work?

I have been creating a very simple spreadsheet and when it came to adding some formulae to it i have noticed some really strange behaviour and was wondering if anyone else has exerienced the same.



As you will be able to see from the attached file, there is nothing complex about this sheet at all, however the formulae that is entered on the "Calculations" sheet appear to display as if they were in formula view (This is not the case).

In cell B10 on sheet "calculations" I have the formula "=SUM(Stock!G10:G43)" and I am getting nothing.
Also on the same sheet there is the formula "=C3+potato", the reference "potato" does not exist and I have no Reference error???????
There is also the formula "=SUM(C10:C11)" (C10=4, C11=1) and the result is 0. I didn't think excel could forget how to count!?!?!

Hopefully someone could help me out here as I am at a complete loss for what to do now.

Thankx in advance.

Florish

------------------------------------------------------------
Who Is General Failure? And Why Is He Reading My Hard Drive?
------------------------------------------------------------
Attached Files
File Type: xls Odd Jewlery Shop.xls (62.5 KB, 3 views)
Reply With Quote
  #2  
Old 01-30-2009, 02:44 PM
caholmes caholmes is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
caholmes is on a distinguished road
Default Simple formula fix

The cells are formatted as Text. You need to format them back to general (Format >> Format Cells) and then click into the formula bar for each formula and then hit enter. This will refresh them and excel will now see them as formulas.
Reply With Quote
  #3  
Old 02-10-2009, 09:45 AM
Schereazade Schereazade is offline Windows XP Office 2003
Novice
 
Join Date: Feb 2009
Posts: 25
Schereazade is on a distinguished road
Default

It seems that some of your cells are formatted as text. When you select the cells you can use the Format option on the main toolbar and change the value from Text to Number.

You also had an error with your SUM function.

It should be =SUM(E10:E11)

Hope this helps :-)
Attached Files
File Type: xls Copy of Odd Jewlery Shop.xls (63.0 KB, 2 views)
Reply With Quote
  #4  
Old 02-17-2009, 07:07 AM
Novice
 
Join Date: Jan 2009
Location: Southampton
Posts: 2
Florish is on a distinguished road
Thumbs up thanks guys

cheers for that guys, i managed to solve it eventually but just didn't understand for a while.

Thanks for your help.
Reply With Quote
  #5  
Old 02-17-2009, 07:33 AM
Schereazade Schereazade is offline Windows XP Office 2003
Novice
 
Join Date: Feb 2009
Posts: 25
Schereazade is on a distinguished road
Default

Glad you found a solution.

Kind regards,

"Zade" :-)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook hyperlinks don't work. russia5 Office 1 05-21-2009 02:20 PM
Can't get Outlook 2007 to work. Janis Outlook 1 02-25-2008 07:53 AM
Simple macro undoable? garon5 Outlook 0 04-20-2007 10:27 AM
Hyperlinks dont work iturnrocks Outlook 0 11-21-2006 10:19 AM
Auto preview wont switch off wildchildpt Outlook 0 08-29-2006 04:21 AM


All times are GMT -7. The time now is 11:38 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft