Anita, Hi,

If you know it is 5.2345 not 5.23 can I assume that the real value is
somewhere else.

Can you tell me what the formula is in B3, and also B4 to see the pattern?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"walkerdayle"
wrote in message
...

Thank you for your suggestion. As an alternative, how can I sum up the
rounded values but not the values in the cell? For example: B3 = 5.23
(but it's really 5.2345) and B4=3.23 (3.23111)

How can I add the two and get the true answer even though B3:B4 are
answers using the ROUND function. Note: I didn't create this
spreadsheet.

Anita

Bob Phillips Wrote:
If you mean that you want to sum the un-rounded values, I think you have
a
problem. If it is values, then how can you possibly know what it was
rounded
from? If it is formula relating to other cells, you might be able to
concoct
a formula that uses those original cells.

If on the other hand it is just formatted to 2 dec places, no problem.
Just
sum them.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"walkerdayle"

wrote in message
...

HELP! I have a problem at work where I have data in 3 columns that
are
derived using the ROUND function to 2 decimal places. In my total
column, I want the values of the data added in it's true form. How
do
I do it?

Hopefully I've explained it right.


--
walkerdayle

------------------------------------------------------------------------
walkerdayle's Profile:
http://www.excelforum.com/member.php...o&userid=10021
View this thread:
http://www.excelforum.com/showthread...hreadid=477508



--
walkerdayle
------------------------------------------------------------------------
walkerdayle's Profile:
http://www.excelforum.com/member.php...o&userid=10021
View this thread: http://www.excelforum.com/showthread...hreadid=477508