[Year 12 IPM] Help Request from Excel Experts please.

[Keith Richardson]

Thank you Brett.
Keith


On Thu, 31 Mar 2005 13:20:26 +1000, "Brett Davies"
<DAVIB at woodleigh.vic.edu.au> said:
> use the round function , round up or round down
> 
> Brett Davies
> Woodleigh School
> Golf Links Road
> Baxter  Vic 3911
> 
> Phone: (03) 5971 1108
> Fax:   (03) 5911 1010
> Mobile: 0411 66 22 55
> davib at woodleigh.vic.edu.au
> 
> 
> >>> keithcr at fastmail.fm 31/03/2005 12:56 pm >>>
> Hi - I have received an Excel query from a workmate that has me stumped,
> and I am wondering if anyone out there in expertsville has an answer.
> Below please find the email he sent me.
> What he wants is for excel to automatically drop of the cents retaining
> only the dollars, and for this new dollar-only value to be fixed (not
> just having the cents invisible but really still there).
> Many thanks, Keith.
> 
> 
> 
> On Wed, 30 Mar 2005 12:05:50 +1000, "Leonard Hain"
> <len.hain at yavneh.vic.edu.au> said:
> > Keith
> > 
> > Further to the query I raised with you the other day regarding the
> > identification of a formula that can be used when adding a row of figures
> > in
> > an excel worksheet, where figures after the decimal point have been
> > rounded
> > off to disclose whole numbers but to still appear if the sum total at the
> > end of the column adds. This is for presentation purposes, where you
> > don't
> > want to explain rounding differences and there are too many line items to
> > manually address the problem.
> > 
> > Using the standard SUM formula or the ROUND formula. you achieve results
> > in
> > the simplest form that look like they don't add, such as 2+2=3. The
> > following example demonstrates.
> > 
> > 
> >       Actual Figure
> >      Elimination of Decimals
> > 
> >       1.51
> >      2
> > 
> >       1.51
> >      2
> > 
> >       3.02
> >      3
> > 
> >       Sum
> >      Sum
> > 
> > 
> > 
> > Can you please advise of an addition formula that addresses this issue.
> > 
> > Leonard Hain
> > Financial Controller
> > Mizrachi Nominees Pty Ltd and
> > Yavneh College Nominees Pty Ltd
> > 
> > Postal Address : P.O. Box 164, South Caulfield 3162
> > Local Address  : 2 Nagle Avenue, Elsternwick 3185
> > Direct Phone     : 61 3 9523-8106
> > Facsimile          : 61 3 9523-7621
> > Email               : len.hain at yavneh.vic.edu.au 
> > 
> > 
> > 
> > 
> > 
> > 
> Keith Richardson
> Leibler Yavneh College
> Elsternwick Ph (03)9528 4911
> keithcr at fastmail.fm 
> 
> _______________________________________________
> ipm mailing list
> ipm at edulists.com.au 
> http://www.edulists.com.au/mailman/listinfo/ipm
> 
> This email and any files transmitted with it are confidential and 
> intended solely for the use of the individual to whom they are 
> addressed.
> If you have received this email in error, please notify 
> Woodleigh School immediately by return email and then delete this 
> message.
> While Woodleigh School makes every attempt to ensure that attached 
> files are virus free, we do not represent or warrant that the 
> attached files are free from computer viruses or other defects.
> 
> 
> _______________________________________________
> ipm mailing list
> ipm at edulists.com.au
> http://www.edulists.com.au/mailman/listinfo/ipm
Keith Richardson
Leibler Yavneh College
Elsternwick Ph (03)9528 4911
keithcr at fastmail.fm