FrumpyJones
New Member
- Joined
- Feb 11, 2008
- Messages
- 28
Hi Everyone,
I tried googling and searching this forum for this question. And either I'm not asking/searching it correctly, or it's simply an "undoable" thing and everyone knows but me.
I want to put a number in say, C1. When I hit enter on that, I want a formula to run that will then convert that number to the result.
I know I can put a formula in D1 that can give me the result C1 + Formula, but is there anyway to have it do it without having to make another visible column?
Example: I want any number put into C1 to be multiplied by 2, and return that value to C1 instead of the number they put in. So:
Is this possible without going all Visual Basic on it?
Thanks for the help
I tried googling and searching this forum for this question. And either I'm not asking/searching it correctly, or it's simply an "undoable" thing and everyone knows but me.
I want to put a number in say, C1. When I hit enter on that, I want a formula to run that will then convert that number to the result.
I know I can put a formula in D1 that can give me the result C1 + Formula, but is there anyway to have it do it without having to make another visible column?
Example: I want any number put into C1 to be multiplied by 2, and return that value to C1 instead of the number they put in. So:
Put 3 into C1, hit enter (or tab).
3*2 = 6
Replace the 3 in C1 with 6 via magic.
3*2 = 6
Replace the 3 in C1 with 6 via magic.
Is this possible without going all Visual Basic on it?
Thanks for the help
Last edited: