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

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.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=376301

= 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
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
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