Forum Discussion
Clebl004
Oct 12, 2023Copper Contributor
When would want to create and solve a formula manually without using a function?
Can someone please explain to me in what scenario would someone want or need to type in a formula and calculate it manually without using a function like SUM or VLOOKUP? Can I also see some examples?...
Detlef_Lewin
Oct 12, 2023Silver Contributor
To be honest I really do not understand your posting.
Is it about calculation mode (manual vs. automatic)?
Or is it about calculating with Excel vs. calculating with pen+paper/calculator?
Both methods require manual typing/writing.
mathetes
Oct 13, 2023Silver Contributor
To be honest I really do not understand your posting.
It WAS an unusual question, for sure. I think the clue to understanding it was that he (she?) described himself (herself) as a total newbie. And the way it was worded was less about the mechanics of Excel than about the underlying philosophy or thinking process one should use in approaching using Excel. It's almost as if he (she) was asking, "What will this tool do for me that I can't do for myself with plain ol' mathematical formulas?"
So it was not at all consistent with the kinds of question that we normally get on these boards--which is why it wouldn't make sense to approach it from that mindset in trying to answer it.
In fact, it would be interesting to know the academic background of Clebl004 (if he or she is still following this) that prompted the original question in the first place.