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

[Robert Hind]

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
>