Hi,
I am a beginner with the functions in excel and wanted to know if it is possible to change the value of one cell with a formula written in another cell.
Any help will be appreciated.
Thanks
Hi,
I am a beginner with the functions in excel and wanted to know if it is possible to change the value of one cell with a formula written in another cell.
Any help will be appreciated.
Thanks
Can you just put another formula in the cell you want changed relative to the other formula with the formula you already have? I don't really understand what you are looking to do.
If you can't figure out how a formula works, try stepping through it using "Evaluate Formula" in the Formula Auditing menu item in the tools menu!
If you want to see where your code went wrong, try stepping through it by clicking in the code and pressing F8 and watch as the magic happens!
If you are happy with any of the results, please add to the contributor's reputation by clicking the star icon.
Formulas can only displaythe information in the cell they are in
To change the data in another cell you
Need another formula in that cell
or
A macro
or
Manual enter the value
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
Why don't you describe/show us through an attachment, what it is that you're attempting to accomplish, I'm sure we'll be able to figure something out for you.
mew.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Sorry for That:
Last edited by randall78; 06-25-2012 at 12:50 PM.
Randall78,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks