View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default one row won't calculate

If it was a formula error than they would of recevied N/A or REF. It sound
more like they added a row and there were no formulas. I would like to see
the templete to find out how new rows should be added.

"John C" wrote:

I don't think he was picking on the trust issue, I think he was more thinking
that most people won't actually download a file if it is just a simple
formula that is in error.
--
John C


"Joel" wrote:

Why wouldn't people download files from a trusted microsoft webpage????

"Peo Sjoblom" wrote:

Well since many of the regulars probably won't go to MS download site and
download this
file maybe you can explain what formulas (I assume it is a lookup formula)
you are using and what does not work?
First thing I would check is if the new student's numbers are in fact text.

--


Regards,


Peo Sjoblom

"Rick" wrote in message
...
I use a grade book which I downloaded from the Microsoft site. It works
great, except when I had to add a new student. The grades do not
calculate
like in the other rows of students. I tried changing the grades of the
other students to make sure it is calculating correctly, and it does. It
is
only for this new student. I also tried entering the grade directly in
the
row, and then into the formula bar, all to no avail.
Any ideas?