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

[Brett Davies]

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.