| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell lookup
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell lookup
Maybe this
="Final cost " & TEXT(A6,"$0.00") Mike "Excel Challenged" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell lookup
Well, if you want the amount in a statement, it would be like:
="Final Cost "&TEXT($A$6,"$#,##0.00") -- ** John C ** "Excel Challenged" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Need to lookup value in cell, dependent on value in another cell | Excel Worksheet Functions | |||
| formatting a cell the same as the source cell from a lookup table | Excel Discussion (Misc queries) | |||
| lookup within a cell | Excel Worksheet Functions | |||
| lookup more than one cell | Excel Worksheet Functions | |||
Linear Mode
