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

[Geoff Moss]

Hi Mark

The formula in A11 is:  =SUM(A1:A10)
Hence you are doubling the numbers A6:A10 by including them in the sub-total 
for Total B

Just a bad formula!
Cheers

Geoff Moss
RMIT

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


--------------------------------------------------------------------------------


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.14.10/1070 - Release Date: 14/10/2007 
9:22 AM