Can I make a formula in Excel to display result in same cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make a cell in which the formula and the entry field are in
the same cell... In other words getting a formula to be locked in a cell to
where whatever info I put in the cell, the locked formula calculates the
entry number.
 
Not without using the f2 key to edit or a worksheet_change macro.
 
You must log in or register to reply here.

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

Similar Threads

Help needed 0
Array formula lock-up 1
Testing a cell value for a specific weekday. 3
formula displays as a formula, not as its result 1
Formula results display only after pressing Enter key 1
Making an excel sheet so formulas can not be deleted in the sum to 2
Excel How to add numbers in same cell? 2
E2007 formulas display as formulas, not results 3

Back
Top