formula

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

Guest

i want to make a formula for the same cell which i want to enter data in it
 
kufo79 wrote :
i want to make a formula for the same cell which i want to enter data in it
Click to expand...

You are not supposed to enter any data if you would like to have a
formula in the same cell, what you enter would replace the formula.
 
This cannot be done!!

Regards.

Bill Ridgeway
Computer Solutions
 
The only way to do this would be to have a VBA Macro running in the
worksheet which checked a particular cell (or cells) for input and
calculated a function on them when data was entered.

Matt
http://teachr.blogspot.com - For Excel Tips and Tutorials
 
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 with ISNUMBER formula 2
Excel Help to copy information from one row at a time to another sheet 1
add new value with previous in same cell 2
SUM / COUNT formula 3
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Countif Problem 2
Building closed workbook file path within an Index Function 6
Retrieving data from a cell in the last row containing data in the worksheet 1

Back
Top