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

[Alex Hopkins]

Yes, but that's where the fun starts.

Set the formula to sum(a1:a5) *before* entering the "1"s, and watch Excel
change the formula as soon as you've entered the sixth value.

I notice that entering a "2" and then changing to a "1" inhibits this odd
behaviour.  What's going on?

-Alex Hopkins
Bayside Christian College

-----Original Message-----
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of P.DiNatale
Sent: Monday, 15 October 2007 3:00 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] Bad, Excel. Bad!

Mark,

Your formula in section A is sum(a1: a10)  it should be sum(a1:a5)



Phillip Di Natale
Outdoor Camps Co-Ordinator
Ph: (03) 9409 8836
email: p.dinatale at stmonicas-epping.com



-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Mark Kelly
Sent: Monday, October 15, 2007 2: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
IT Lecture notes: 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 - 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  - VITTA Victorian Information Technology
Teachers Association Inc 
--------------------------------------------------------
 
This Email and any attachments may be confidential and, if you are not the
intended recipient, you must not disclose or use the information in this
mail. If received in error, please notify the sender or the College
immediately and delete the Email and all copies. The school does not
guarantee that this Email is virus or error free. Any attached files may
only be used on the basis that the user assumes all responsibility for any
loss, damage or consequence resulting directly or indirectly from the use of
the attached files, whether caused by the negligence of the sender or not.
The content and opinions in this Email are not necessarily those of the
school. 
--------------------------------------------------------
 
 
 
 
 

_______________________________________________
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  - VITTA Victorian Information Technology Teachers
Association Inc