Hi I am new to the forums so sorry if this is in the wrong thread. I have a question I am trying to see if there is a way to basically make a cell a calculator by getting it to add numbers that I put in it. For example if cell b3 has the value of 20 if I could add 20 to it and make it 40 now. I know how to do simple formulas like adding b3 and b4 together but I want just a cell for this alone. thank you for your help.
Hello and welcome to the forum,
If you want to input the number in the same cell as the result then it will require a user-defined function or a change event (both requiring vba). Would this suffice your needs?
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
You could just input
Formula:
=20+20
EDIT: ...or follow up on abousetta's suggestion...
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Thanks for the help I know what I need to do know.
Let me know if you would like help with either solution I suggested. Just let me know whkch cell you want to use.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
spreadsheetnovice 
Register To Reply
Bookmarks