Hi
Joe,
Yes, it is possible for a text box in
Microsoft Excel to reference a cell that contains a formula or a cell reference. Here are the steps to do so:
- Click on the text box to select it.
- In the formula bar, type an equal sign (=) to indicate that you want to enter a formula.
- Type the cell reference that you want to reference. In your case, it would be .
- Press Enter to apply the formula to the text box.
Now, the text box will display the result of the formula in cell C25. If you change the value in cell C25, the text box will automatically update to reflect the new value.