Bad mark ! Re: [Year 12 IT Apps] Bad, Excel. Bad!

[Robert Hind]

PS

I have no idea how Excel got you into that situation. Don't you just hate 
those "I know better than you do" corrections made by Word and also 
obviously by Excel.

Robert Hind (Semi-retired)
Ex Traralgon and Ashwood

----- Original Message ----- 
From: "Robert Hind" <robert at yinnar.com>
To: "Year 12 IT Applications Teachers' Mailing List" 
<itapps at edulists.com.au>
Sent: Monday, October 15, 2007 3:40 PM
Subject: Bad mark ! Re: [Year 12 IT Apps] Bad, Excel. Bad!


> Your formula in cell A11 reads
>
> =SUM(A1:A10)
>
> it should read
>
> =SUM(A1:A5)
>
> Robert Hind (Semi-retired)
> Ex Traralgon and Ashwood
>
> ----- Original Message ----- 
> From: "Mark Kelly" <kel at mckinnonsc.vic.edu.au>
> To: "Year 12 IT Applications Teachers' Mailing List" 
> <itapps at edulists.com.au>
> Sent: Monday, October 15, 2007 2:50 PM
> 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
>
>
> _______________________________________________
> 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
>
>