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