= 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