5 posts shown.
brightcyclist2 said:Are you absolutely certain you want the formula itself to be visible rather than just the actual result within cell F-19? 😕
edit: I noticed your title mentions multiplying 😕
which seems a bit off if your intention was actually F-19=200/G19 😕
God of Lava,
You’re right about the title—I suppose I should have been more precise there; what I really need is for the formula to remain visible in F-19, even though it needs to contain the specific number I'd get from that division process.
Hey guys,
So, I have this specific cell (G19) that I’ve been using to calculate an "Average"—for instance, by using =AVERAGE(G12:G17)
Right now, my Activecell F19 is selected. What I'm trying to do is take an integer (let's say 200) and divide it by the value in that G19 cell, then save that result directly into F19—but here's the catch: I want the actual formula to remain visible within cell F19 itself. I might have overcomplicated things a bit in my explanation, so I really hope you can follow what I'm getting at. I was attempting to use formula R1C1 to get it done.
God bless everyone. I am currently working with two different Macros that interact with my Excel application. Essentially, the first Macro serves as an audit tool to track all the changes happening within the Excel file, while the second one handles various mathematical calculations. The issue I am running into—and I hope I am explaining this clearly enough—is that when I run the second Macro, the first one (the audit tool) needs to be turned off entirely. Once I have finished with the calculations, I then need to turn the first Macro back "on." It is a bit of a juggling act, really, as they need to be toggled on and off sequentially.
For instance, let's say Macro 1 is Macro_Audit, and Macro 2 is Macro_calc..
Thanks so much
Honestly, I think Markan is a total legend—he’s just closer to the heart of things. The more people try to spit lies and tear him down, the more I find myself rooting for Thompson; he’s just much more dear to us. 🙂
Mr. X said:Happy Christmas to everyone celebrating😉—wishing you and your families all the very best during the holidays. Best, your old pal🙂
I suppose we'll touch base again once we hit New Year's Day😈
Now, Mr. X, who's stopping you from celebrating? Or is your holiday break already over after just two weeks? :-))))))