Microsoft Office Excel 2003 for PC Logo
Anonymous
Anonymous Posted on Nov 05, 2009
Answered

Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if one of those columns has a zero value. These problems are intermittant - they work on some sheets but not on others - can you advise please.

Answer This Question

2 Answers

David Shaub

Level 3:

An expert who has achieved level 3 by getting 1000 points
All-Star:

An expert that got 10 achievements.
MVP:

An expert that got 5 achievements.
President:

An expert whose answer got voted for 500 times.

  • Microsoft Master 2,994 Answers
  • Posted on Nov 05, 2009
David Shaub
Microsoft Master
Level 3:

An expert who has achieved level 3 by getting 1000 points
All-Star:

An expert that got 10 achievements.
MVP:

An expert that got 5 achievements.
President:

An expert whose answer got voted for 500 times.

Joined: Jan 01, 2009
Answers
2994
Questions
2
Helped
1153483
Points
8370

Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Testimonial: "Thanks for your response - will look closely at your reply - the problem works in some areas and not in others so I know it isnt a cell value problem."

Anonymous

Level 2:

An expert who has achieved level 2 by getting 100 points
All-Star:

An expert that got 10 achievements.
MVP:

An expert that got 5 achievements.
Vice President:

An expert whose answer got voted for 100 times.

  • Expert 292 Answers
  • Posted on Nov 05, 2009
Anonymous
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points
All-Star:

An expert that got 10 achievements.
MVP:

An expert that got 5 achievements.
Vice President:

An expert whose answer got voted for 100 times.

Joined: Aug 20, 2009
Answers
292
Questions
1
Helped
86164
Points
699

Hi gail876
When you write a formula
remember the following:

  • begin with an = sign
  • do not include space or any unwanted characters in the formula.
  • For example: =c3+d5 is correct: but c3 + d5 is not correct
  • capital letters OR small letters can be used in the formula.
If you write the formula correctly they will work
Division by 0 gives an error, but 0 can be added, subtracted, multiplied and divided
0/15 = 0 BUT 15/0 is ERR
eg: type 0 in C3 and 25 in C4
Now go to A10 and write the formula like this ( no spaces) =c3/c4 and press ENTER key
Now the cell A10 displays the answer 0
Go to A11 and type the formula =c4/c3 and press ENTER key.
Now the cell A11 displays the answer ERR caused by DIVISION by ZERO
If any cell shows ERR, then every cell which uses that cell in a formula displays ERR as well. So, ERR is propogated.

So, the lesson is write the formula correctly, and never write a formula where denominator is 0 (DIV by ZERO)
Hope this answer help you.
Have a good day.
luciana44


Testimonial: "Thank you for your help"

  • Ramiro Burr Jun 20, 2014

    Luciana is right,

  • Ramiro Burr Jun 20, 2014

    Luciana is right,do this carefully:

×

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2helpful
2answers

What is formula to find percentage of females in my workplace?
      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

      https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
    Feedback

    How to Calculate Percentages in Excel

    www.excelfunctions.net > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet

    https://exceljet.net/formula/get-percentage-of-total
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.
Read full answer
Jan 19, 2016 • Computers & Internet
1helpful
2answers

What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.
Read full answer
Aug 19, 2011 • Microsoft EXCEL 2004 for Mac
0helpful
1answer

Whenever I work in excel 2007 file.It show compatibility mode n top and any formula are not working properly in file.
When you open Office 2003 files with Office 2007, it works in compatibility mode, so that if you open the files in earlier version (i.e. Office 2003 etc) there would be no issues (reverse compatibility with earlier versions.
Regarding formulas, rest assure that compatibility mode does NOT affect the calculations at all. All formulas are reverse compatible.
So, it is recommended that you may save the file in Word/ Office2007 format. Do review your formulas for errors (if any).

CreativeTECH
Read full answer
May 16, 2011 • Computers & Internet
0helpful
2answers

FORMULA PROBLEM IN MS EXCEL
The cells you are trying to sum are probably text and not numeric values. Format them as number or convert them to numbers.
Read full answer
Apr 18, 2009 • Microsoft Office Excel 2003 for PC
1helpful
1answer

How to calculate the difference of two dates by year, month and day using the formula in excel?
To calculate the difference in Years use =Year(c,r)-Year(c,r)
To calculate the difference in Months use =Month(c,r)-Month(c,r)
To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates
Read full answer
Mar 15, 2009 • Microsoft Office Excel 2003 for PC
2helpful
6answers

Examples for MS Excel formulas
www.google.com
Read full answer
Jan 14, 2009 • Microsoft Office Excel 2003 for PC
0helpful
2answers

Formula for calculating the days beween months
for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)
Read full answer
Aug 25, 2008 • Microsoft Office Professional 2007:...
0helpful
5answers

How many formulas we can use at a time in Excel
That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.
Read full answer
Apr 04, 2008 • Microsoft Excel for PC
0helpful
1answer

Excel formula
the formulae for the surface area of round disc is
pi * r * r
where pi=3.14 and r =radious of disc= diametre/2 

for this 1st u have 2 calculate the radious of the disc that is
180/2=90mm
then convert it to  m by dividing 1000 ,so radious=90/1000=0.09 m
finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres
for 38 disc multiply 38 with the above area that is
0.025434 * 38=0.966492 sq metres

in excel 2007  u can do it more easily by going 2 formulas tab.
Under formla tab click on engineering formula and  then convert
here u can convert from mm to m
after converting use the above formula i just told u.
Read full answer
Feb 27, 2008 • Computers & Internet
1helpful
3answers

Formulas of excel
  1. formula
Read full answer
Nov 15, 2007 • Microsoft Office 2003 Basic Edition...
Not finding what you are looking for?

View Most Popular

Office Excel 2003 for PC

  • Computers & Internet

Related Question

What is formula to find percentage of females in my workplace?

  • Computers & Internet

Related Topics

304 views

Ask a Question

Usually answered in minutes!

Popular Questions

Get message that "Setup cannot find Office.en-us\OfficeMUI.msi"

Microsoft Office Professional 2007...

Hi i need micro soft visio 2010 product key

Microsoft Office Standard for PC

PROBLEM OF PRO11.MSI

Microsoft Office 2003 Pro...

HOW TO DOWNLOAD MS OFFICE 2007 FULL VERSION FREE

Microsoft Office Professional 2007...

Confirmation code

Microsoft Office Professional 2007...

Check Out the Mobile Browsers Report
Check Out the Mobile Browsers Report

View all Fixya Reports

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...