Re: Newbie peroblem with calculating values in cells

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Wed, 05 Apr 2006 05:01:39 GMT,
bruce.sinclair@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (Bruce Sinclair) wrote:

In article <ob2632l9rrjfishil657loo6eeqfp3c7ef@xxxxxxx>, Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx> wrote:
On Tue, 04 Apr 2006 23:54:04 GMT, "Ike" <accordiondocxyzxyzxyz@xxxxxxxxxxxxxx>
wrote:

After reading the file as you suggested, I was of the impression that the
TRUNC command would not be appropriate since it would seem from the
description that it truncates to whole numbers. What I would like to do is
select a column of figures --generated by the same formula in this
instance-- and round every figure in it to two decimal places.

Well, now you are writing you want to ROUND the figures to two decimal places.
Before you wrote you wanted to TRUNCate the figures to two decimal places.
You've gotten me very confused.

TRUNC should satisfy your first request.
ROUND should satisfy your second request.

.. and if all you want to do is to show some kind of currency format (the
most common reason for using 2 decimal places :) ) then you could simply
display the numbers as currency instead.

Bruce


If you are recommending using the currency format in the cell, the OP should be
aware that would result in ROUNDing the display only, and have no effect on the
actual value stored in the cell.

At least initially, the OP indicated he wanted to TRUNCate the result (or
possibly ROUND the result).


--ron
.

Quantcast