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

[Keith Richardson]

Many thanks Robert.
Regards, Keith



On Thu, 31 Mar 2005 13:25:05 +1000, "Robert Hind"
<roberthind at m150.aone.net.au> said:
> Try the INT() function
> 
> Robert Hind
> 
> Ashwood College
> ----- Original Message ----- 
> From: "Keith Richardson" <keithcr at fastmail.fm>
> To: "List IP&M" <ipm at fhc.vic.edu.au>
> Sent: Thursday, March 31, 2005 12:56 PM
> Subject: [Year 12 IPM] Help Request from Excel Experts please.
> 
> 
> > 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
> > 
> 
> 
> _______________________________________________
> 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