K
kufo79
i want to make a formula for the same cell which i want to enter data in it
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jack Zhong
kufo79 wrote :
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.
i want to make a formula for the same cell which i want to enter data in it
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.
B
Bill Ridgeway
This cannot be done!!
Regards.
Bill Ridgeway
Computer Solutions
Regards.
Bill Ridgeway
Computer Solutions
M
mattyboy150279
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
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