• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

Why does Excel not calculate my formula ?

Hi,

I have an Excel 2007 worksheet which ignores the formulas I enter, even simple ones like =SUM(6,10). It just displays the formula as if it's text.

The Calculation Options are set to Automatic but even a Manual calculation makes no difference. How can this happen ?

Toco
0
Tocogroup
Asked:
Tocogroup
  • 2
  • 2
  • 2
  • +2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

One possiibility:

Is your workbook showing Formulas instead of values? Hold down the Ctrl key and hit the ~ sign (the key to the left of the 1 on a US keyboard) to toggle between the views.

cheers, teylyn
0
 
jppintoCommented:
Check on you Formulas tab, on Calculation Option to see if it's set to Automatic. Pressing F9 to calculate, does it calculate?
0
 
TocogroupAuthor Commented:
Actually Teylyn I think it's more basic than that.

If the format of the cell is text, will it ignore the = sign as a formula symbol ?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Neil RussellTechnical Development LeadCommented:
Most likely the cells are formatted as TEXT

IF cells are formatted as text and THEN you enter a string like =9*8

It will show =9*8

Format cells as general
0
 
jppintoCommented:
yes!
0
 
Neil RussellTechnical Development LeadCommented:
Ha looks like you spotted it while i typed it!
Yes thats correct thats why
0
 
Saqib Husain, SyedEngineerCommented:
press ctrl-~
0
 
TocogroupAuthor Commented:
Thanks for the confirmation.
Bit embarrassed about this one as I've never come across this before. Commonsense really.
Thanks again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now