Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2000:cell value dependent on other cell value 1

Status
Not open for further replies.

SnapperBart

Programmer
Oct 21, 2001
8
CA
In cell A1 I have the following:
First Database (n=X)

I want to automatically change the value of X to the cell value in A2, leaving everything else intact in A1. For e.g., if A2=13, I would like A1 to show as:
First Database (n=13)

Any thoughts on how I could accomplish this? Thanks.
 
Enter your formula for A1 as

="First Database (n="&A2&")"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top