[Year 12 IT Apps] Just an oldie! But can we please identify
ourselves?
Robert Hind
robert at yinnar.com
Mon Oct 15 18:27:01 EST 2007
Hi Selina,
A good contribution to the list.
But
Could you please identify yourself more clearly/fully J
Robert Hind (Semi-retired)
Ex Traralgon and Ashwood
----- Original Message -----
From: "Selina Dennis" <selina at dennis.net.au>
To: "'Year 12 IT Applications Teachers' Mailing List'" <itapps at edulists.com.au>
Sent: Monday, October 15, 2007 5:59 PM
Subject: RE: [Year 12 IT Apps] Bad, Excel. Bad!
> =SUM($A$1:$A$5) also fixes the problem, if you wish to retain the
> "built-in-I-know-better" error correction.
>
> Regards,
>
> Selina
>
> -----Original Message-----
> From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
> On Behalf Of Mark Kelly
> Sent: Monday, 15 October 2007 4:33 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Bad, Excel. Bad!
>
> Sorry for the confusion all. The formula was originally sum(a1:a5) - as
> it should have been - but I forgot to undo Excel's botched "correction"
> before saving and posting it.
>
> It started as sum(a1:a5)!
>
> The problem is as Alex notes - after filling in A1:A5, Excel starts
> changing the formula! That's why it _ended up_ as SUM(A1:A10) - and
> that's where you entered the story :-)
>
> Cheers
> Mark
>
> Geoff Moss wrote:
>> 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
>>
>> _______________________________________________
>> 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
>>
>>
>
> --
> Mark Kelly
> Manager - Information Systems
> McKinnon Secondary College
> McKinnon Rd, McKinnon 3204, Victoria, Australia
> Direct line / Voicemail: 8520 9085
> School Phone +613 8520 9000, 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
>
> 1. Education is an admirable thing, but remember that nothing that is
> worth knowing can be taught - Oscar Wilde
> 2. I make trouble. You want some?
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20071015/990b44b0/attachment.html
More information about the itapps
mailing list