Dueling Excel 130


Text Formula To Show Calculation (Not Formula) From A Cell
See Mr Excel and excelisfun use two methods to show formula calculation in a cell:
1. Use Ampersand (Join Symbol), Text in Double Quotes, and Cell References
2. Use CONCATENATE function, Text, and Cell References
3. Use the ADDRESS function and the ROW and COLUMN function to dynamically display a cell reference in a Text Formula.


Be the first to comment

Leave a Reply