<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16544" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=Arial>Hi Selina,</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>A good contribution to the list.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>But</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Could you please identify yourself more clearly/fully
</FONT><STRONG><FONT face=Wingdings size=7>J</FONT></STRONG></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Robert Hind (Semi-retired)<BR>Ex Traralgon and
Ashwood</FONT></DIV>
<DIV><FONT face=Arial><BR> </DIV></FONT>
<DIV><FONT face=Arial>----- Original Message ----- </FONT>
<DIV><FONT face=Arial>From: "Selina Dennis" <</FONT><A
href="mailto:selina@dennis.net.au"><FONT
face=Arial>selina@dennis.net.au</FONT></A><FONT face=Arial>></FONT></DIV>
<DIV><FONT face=Arial>To: "'Year 12 IT Applications Teachers' Mailing List'"
<</FONT><A href="mailto:itapps@edulists.com.au"><FONT
face=Arial>itapps@edulists.com.au</FONT></A><FONT face=Arial>></FONT></DIV>
<DIV><FONT face=Arial>Sent: Monday, October 15, 2007 5:59 PM</FONT></DIV>
<DIV><FONT face=Arial>Subject: RE: [Year 12 IT Apps] Bad, Excel.
Bad!</FONT></DIV></DIV>
<DIV><FONT face=Arial><BR></FONT></DIV><FONT face=Arial>> =SUM($A$1:$A$5)
also fixes the problem, if you wish to retain the<BR>>
"built-in-I-know-better" error correction.<BR>> <BR>> Regards,<BR>>
<BR>> Selina<BR>> <BR>> -----Original Message-----<BR>> From:
</FONT><A href="mailto:itapps-bounces@edulists.com.au"><FONT
face=Arial>itapps-bounces@edulists.com.au</FONT></A><FONT face=Arial>
[mailto:itapps-bounces@edulists.com.au]<BR>> On Behalf Of Mark Kelly<BR>>
Sent: Monday, 15 October 2007 4:33 PM<BR>> To: Year 12 IT Applications
Teachers' Mailing List<BR>> Subject: Re: [Year 12 IT Apps] Bad, Excel.
Bad!<BR>> <BR>> Sorry for the confusion all. The formula was
originally sum(a1:a5) - as <BR>> it should have been - but I forgot to undo
Excel's botched "correction" <BR>> before saving and posting it.<BR>>
<BR>> It started as sum(a1:a5)!<BR>> <BR>> The problem is as Alex notes
- after filling in A1:A5, Excel starts <BR>> changing the formula!
That's why it _ended up_ as SUM(A1:A10) - and <BR>> that's where you entered
the story :-)<BR>> <BR>> Cheers<BR>> Mark<BR>> <BR>> Geoff Moss
wrote:<BR>>> Hi Mark<BR>>> <BR>>> The formula in A11 is:
=SUM(A1:A10)<BR>>> Hence you are doubling the numbers A6:A10 by including
them in the <BR>>> sub-total for Total B<BR>>> <BR>>> Just a
bad formula!<BR>>> Cheers<BR>>> <BR>>> Geoff Moss<BR>>>
RMIT<BR>>> <BR>>> ----- Original Message ----- From: "Mark
Kelly"<BR>> <</FONT><A href="mailto:kel@mckinnonsc.vic.edu.au"><FONT
face=Arial>kel@mckinnonsc.vic.edu.au</FONT></A><FONT face=Arial>><BR>>>
To: "Year 12 IT Applications Teachers' Mailing List" <BR>>> <</FONT><A
href="mailto:itapps@edulists.com.au"><FONT
face=Arial>itapps@edulists.com.au</FONT></A><FONT face=Arial>><BR>>>
Sent: Monday, October 15, 2007 2:50 PM<BR>>> Subject: [Year 12 IT Apps]
Bad, Excel. Bad!<BR>>> <BR>>> <BR>>>> A curious problem
with Excel. Please play with the attached
file.<BR>>>><BR>>>> It seems Excel thinks it knows better than
I do about what formulas<BR>>>> should be, and I can't work how how to
stop it. Something to do with<BR>>>> its 'advanced formula error'
fixing, I guess. Very annoying!<BR>>>><BR>>>> To try it
out, just put "1" into each of the shaded cells and watch what<BR>>>>
happens to the formula for the total of section
A!<BR>>>><BR>>>> Any ideas for
fixes?<BR>>>><BR>>>> TIA<BR>>>>
Mark<BR>>>><BR>>>> -- <BR>>>> Mark
Kelly<BR>>>> Manager - Information Systems<BR>>>> McKinnon
Secondary College<BR>>>> McKinnon Rd McKinnon 3204, Victoria,
Australia<BR>>>> Direct line / Voicemail: 8520 9085<BR>>>>
School Phone +613 8520 9000<BR>>>> School Fax +613
95789253<BR>>>> kel AT
mckinnonsc.vic.edu.au<BR>>>><BR>>>> Webmaster - </FONT><A
href="http://www.mckinnonsc.vic.edu.au"><FONT
face=Arial>http://www.mckinnonsc.vic.edu.au</FONT></A><BR><FONT
face=Arial>>>> IT Lecture notes: </FONT><A
href="http://vceit.com"><FONT face=Arial>http://vceit.com</FONT></A><BR><FONT
face=Arial>>>> Moderator: IT Applications Mailing
List<BR>>>><BR>>>> You'll know when we are officially a
civilised race: our schools have<BR>>>> all the money they need and the
Air Force has to run a chook raffle to<BR>>>> buy a new
bomber.<BR>>>>
_______________________________________________<BR>>>> </FONT><A
href="http://www.edulists.com.au"><FONT
face=Arial>http://www.edulists.com.au</FONT></A><FONT face=Arial> - FAQ,
resources, subscribe, unsubscribe<BR>>>> IT Applications Mailing List
kindly supported by<BR>>>> </FONT><A
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><FONT
face=Arial>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</FONT></A><FONT
face=Arial> <BR>>>> - Victorian Curriculum and Assessment Authority
and<BR>>>> </FONT><A href="http://www.vitta.org.au"><FONT
face=Arial>http://www.vitta.org.au</FONT></A><FONT face=Arial> - VITTA
Victorian Information Technology <BR>>>> Teachers Association
Inc<BR>>> <BR>>> <BR>>><BR>>
----------------------------------------------------------------------------<BR>>
---- <BR>>> <BR>>> <BR>>> <BR>>> No virus found in this
incoming message.<BR>>> Checked by AVG Free Edition.<BR>>> Version:
7.5.488 / Virus Database: 269.14.10/1070 - Release Date: <BR>>> 14/10/2007
9:22 AM<BR>>> <BR>>>
_______________________________________________<BR>>> </FONT><A
href="http://www.edulists.com.au"><FONT
face=Arial>http://www.edulists.com.au</FONT></A><FONT face=Arial> - FAQ,
resources, subscribe, unsubscribe<BR>>> IT Applications Mailing List
kindly supported by<BR>>> </FONT><A
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><FONT
face=Arial>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</FONT></A><FONT
face=Arial> - <BR>>> Victorian Curriculum and Assessment Authority
and<BR>>> </FONT><A href="http://www.vitta.org.au"><FONT
face=Arial>http://www.vitta.org.au</FONT></A><FONT face=Arial> - VITTA
Victorian Information Technology <BR>>> Teachers Association
Inc<BR>>> <BR>>> <BR>> <BR>> -- <BR>> Mark Kelly<BR>>
Manager - Information Systems<BR>> McKinnon Secondary College<BR>>
McKinnon Rd, McKinnon 3204, Victoria, Australia<BR>> Direct line / Voicemail:
8520 9085<BR>> School Phone +613 8520 9000, Fax +613 95789253<BR>> kel AT
mckinnonsc.vic.edu.au<BR>> <BR>> Webmaster - </FONT><A
href="http://www.mckinnonsc.vic.edu.au"><FONT
face=Arial>http://www.mckinnonsc.vic.edu.au</FONT></A><BR><FONT face=Arial>>
IT Lecture notes: </FONT><A href="http://vceit.com"><FONT
face=Arial>http://vceit.com</FONT></A><BR><FONT face=Arial>> Moderator: IT
Applications Mailing List<BR>> <BR>> 1. Education is an admirable thing,
but remember that nothing that is <BR>> worth knowing can be taught - Oscar
Wilde<BR>> 2. I make trouble. You want some?<BR>> <BR>>
_______________________________________________<BR>> </FONT><A
href="http://www.edulists.com.au"><FONT
face=Arial>http://www.edulists.com.au</FONT></A><FONT face=Arial> - FAQ,
resources, subscribe, unsubscribe<BR>> IT Applications Mailing List kindly
supported by<BR>> </FONT><A
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><FONT
face=Arial>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</FONT></A><FONT
face=Arial> -<BR>> Victorian Curriculum and Assessment Authority and<BR>>
</FONT><A href="http://www.vitta.org.au"><FONT
face=Arial>http://www.vitta.org.au</FONT></A><FONT face=Arial> - VITTA
Victorian Information Technology Teachers<BR>> Association Inc<BR>>
<BR>> _______________________________________________<BR>> </FONT><A
href="http://www.edulists.com.au"><FONT
face=Arial>http://www.edulists.com.au</FONT></A><FONT face=Arial> - FAQ,
resources, subscribe, unsubscribe<BR>> IT Applications Mailing List kindly
supported by<BR>> </FONT><A
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><FONT
face=Arial>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</FONT></A><FONT
face=Arial> - Victorian Curriculum and Assessment Authority and<BR>>
</FONT><A href="http://www.vitta.org.au"><FONT
face=Arial>http://www.vitta.org.au</FONT></A><FONT face=Arial> - VITTA
Victorian Information Technology Teachers Association Inc<BR>>
<BR>></FONT></BODY></HTML>