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

[Sheard, Brian B]

Keith
 
I've only just seen the discussion about this and as I see it the easiest way to deal with this has to be to set the cells/columns/rows where this calculation is needed to 0 decimal places. Does this meet the criteria necessary?
 
Brian

________________________________

From: ipm-bounces at edulists.com.au on behalf of Keith Richardson
Sent: Thu 31-March-2005 3:39 PM
To: Year 12 Information Technology Processing and Management Teachers'Mailing List
Subject: Re: [Year 12 IPM] Help Request from Excel Experts please.



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

_______________________________________________
ipm mailing list
ipm at edulists.com.au
http://www.edulists.com.au/mailman/listinfo/ipm




Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 8334 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20050401/d921f62c/attachment-0001.bin