cell lookup

  • Thread starter Thread starter Excel Challenged
  • Start date Start date
E

Excel Challenged

I have a value in one cell and I would like that value to update
automatically in my spreadsheet when it is changed. For instance, I have
$17.00 in cell A6 elsewhere in the spreadsheet I need to reference cell A6 in
a statement like "Final cost $17.00", having the $17.00 update if cell A6 is
changed to say $19.00. I am sure this possible with the right formula, but I
have not been able to get it to work. Any help would be appreciated.
 
Well, if you want the amount in a statement, it would be like:
="Final Cost "&TEXT($A$6,"$#,##0.00")
 
Back
Top