decimal places within a formula

Is there a way to set up a number within an equation to have onlyt 2 decimal places? The cells are already formatted to have this, but the data within the cells contains more decimal places which is what is used when the sum() function is run. Since the anwser to this function is used in comparison with other numbers, the answer needs to come out to 2 decimal places in order to match up.

There's an option in the main options dialog to use "precision as displayed" which would cause it to only use the two decimal places displayed.

= int (sum(X:X)*100) / 100



"Paul01" wrote:

>
> Is there a way to set up a number within an equation to have onlyt 2
> decimal places? The cells are already formatted to have this, but the
> data within the cells contains more decimal places which is what is
> used when the sum() function is run. Since the anwser to this function
> is used in comparison with other numbers, the answer needs to come out
> to 2 decimal places in order to match up.
>
>
> --
> Paul01
> ------------------------------------------------------------------------
> Paul01's Profile: http://www.excelforum.com/member.php...o&userid=24012
> View this thread: http://www.excelforum.com/showthread...hreadid=376301
>
>

On Fri, 3 Jun 2005 09:51:50 -0500, Paul01
<[email protected]> wrote:

>
>Is there a way to set up a number within an equation to have onlyt 2
>decimal places? The cells are already formatted to have this, but the
>data within the cells contains more decimal places which is what is
>used when the sum() function is run. Since the anwser to this function
>is used in comparison with other numbers, the answer needs to come out
>to 2 decimal places in order to match up.

*array-enter*

=SUM(ROUND(A1:A10,2))

To *array-enter*, hold down <ctrl><shift> while hitting <enter>. Excel will
place braces {...} around the formula.


--ron

On Fri, 3 Jun 2005 09:31:03 -0700, TomHinkle
<[email protected]> wrote:

>= int (sum(X:X)*100) / 100


You may be correct in deciphering what the OP wants.

But I would point out that your procedure will give different results from
adding up the entries rounded first to two decimal places.


--ron