Sometimes when I use a formula in Excel 2003 it

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

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.