[Year 12 IT Apps] Bad, Excel. Bad!

[Thomas, Caroline M]

Mark
The formula for section A somehow is going down to A10 for its range.  I have changed section A' s formula range to a1:A5 instead of A10, and if I have understood the problem clearly, then this seems to work. See attached.
 
Regards
 
Caroline Thomas
 
Baimbridge College, Hamilton
85 Stephen Street
HAMILTON  VIC 3300
Ph 03 5572 2788
Fax 03 5572 5811
thomas.caroline.m at edumail.vic.gov.au

________________________________

From: itapps-bounces at edulists.com.au on behalf of Mark Kelly
Sent: Sun 14-October-2007 4:50 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Bad, Excel. Bad!



A curious problem with Excel.  Please play with the attached file.

It seems Excel thinks it knows better than I do about what formulas
should be, and I can't work how how to stop it.  Something to do with
its 'advanced formula error' fixing, I guess.  Very annoying!

To try it out, just put "1" into each of the shaded cells and watch what
happens to the formula for the total of section A!

Any ideas for fixes?

TIA
Mark

--
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 95789253
kel AT mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au <http://www.mckinnonsc.vic.edu.au/> 
IT Lecture notes: http://vceit.com <http://vceit.com/> 
Moderator: IT Applications Mailing List

You'll know when we are officially a civilised race: our schools have
all the money they need and the Air Force has to run a chook raffle to
buy a new bomber.
_______________________________________________
http://www.edulists.com.au <http://www.edulists.com.au/>  - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian Information Technology Teachers Association Inc 


Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 19636 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20071015/c1993990/attachment-0001.bin