cell lookup

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.
 
J

John C

Well, if you want the amount in a statement, it would be like:
="Final Cost "&TEXT($A$6,"$#,##0.00")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top