Is there any way to display a rounded number in a cell, but use the
original unrounded number when other cells reference that cell in a
calculation? It would be a pain to use the components of the rounded
cell in the calculation in which i would need the unrounded number.

I need a function that displays a rounded number, but uses the
unrounded number in calculations.


--
mattflow
------------------------------------------------------------------------
mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129
View this thread: http://www.excelforum.com/showthread...hreadid=395350