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

[Murray O.]

Hi Keith
Try TRUNC function
Below is some info from help

Truncates a number to an integer by removing the fractional part of the
number.

Syntax

TRUNC(number,num_digits)

Number    is the number you want to truncate.

Num_digits    is a number specifying the precision of the truncation. The
default value for num_digits is 0 (zero).

Remark

TRUNC and INT are similar in that both return integers. TRUNC removes the
fractional part of the number. INT rounds numbers down to the nearest
integer based on the value of the fractional part of the number. INT and
TRUNC are different only when using negative numbers: TRUNC(-4.3) returns
-4, but INT(-4.3) returns -5 because -5 is the lower number.

regards
Oliver Murray
Web Developer
Westbourne Grammar School
www.westbournegrammar.com

-----Original Message-----
From: Keith Richardson [mailto:keithcr at fastmail.fm] 
Sent: Thursday, 31 March 2005 12:56 PM
To: List IP&M
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