You may have more success getting a helpful answer if you give more
details. What do you mean by "derived number"? You also need to
understand that a formula can't change the value in another cell (that
would require VBA code). Also, a formula can't change precision (or
formatting -- conditional formatting being the exception), and
formatting is required to set the precision that Excel displays.

More info, please

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=393862