View Single Post
  #4   Report Post  
nsv
 
Posts: n/a
Default need a refresher: text boxes on charts that use relational formulas?


This might be old hat, but just in case you have not heard of the
trick:
Assume you have the result of your calculations in cell A1 and A2. In
cell B1 you write:
="Result of Calculations "&A1&" and "&A2
and then refer to cell B1 in the textbox.

Often the result is not a nice number and the you get all the
13-or-whatever digits. One solution is to write
="Result of calculations "&ROUND(A1,2-INT(LOG(ABS(A1))))&" and
"&ROUND(A2,2-INT(LOG(ABS(A2))))
but you can also round down in another cell and refer to that.

NSV


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=479225