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

[Timmer-Arends]

look in tools menu -> options ->edit->extend data range formats anf formulas

I think that's the 'helpful' culprint

regards
Robert T-A
Brighton SC



----- Original Message ----- 
From: "Alex Hopkins" <a.hopkins at bcc.vic.edu.au>
To: "'Year 12 IT Applications Teachers' Mailing List'" 
<itapps at edulists.com.au>
Sent: Monday, October 15, 2007 3:10 PM
Subject: RE: [Year 12 IT Apps] Bad, Excel. Bad!


> 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
>
> _______________________________________________
> 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