Forum Discussion
Formulas for automatic calculations
That is about as broad a question as you could possibly ask!!
So I'll give you a VERY general answer. If you need something more specific, you'll need to come back with a bit more of an explanation.
I'm going to assume you know how to write the formula(s) you have in mind.
I'm further going to assume that you are asking your client for, oh, three pieces of information, and that they'll be asked to enter those pieces of information in Cells A2, A3, and A4
Then here are the steps:
- write something in Cell A1 along the lines of "Please enter the required info below"
- in Cells B2, B3 and B4 I'd "name" or give a title of some kind to the info expected in those adjacent cells.
- give the data entry cells a light yellow background and black cell border, to emphasize "this is where you enter the info"
- write whatever formulas you want or need, making appropriate references to those entered items of information.
- to really make it fool-proof, protect the rest of the sheet so they could not change anything other than cells A2, A3 and A4
Now, if the heart of your question was on the "different formulas" in "different columns" -- then at least some of those formulas might be conditional, or you'd only use one or the other depending (conditionally) on what was entered, then you need to know how to use if various IF and other conditional formulas.
As I said, though, if you're looking for more specific help, please come back with a more complete description, and even (ideally) a sample of the spreadsheet you'd like to create.
Hello!
I have something on my mind, like that. And if I can explain myself, could you help me?
I need to make a board, writing Zone A to Zone B and calculate the time between each other.
I mean, there's a list of places and I need to assign each one a zone. After that, from a drop down list or however possible, make a calculation between them.
Ex:
The "23rd market" is Zone 2, and the "Law School" is Zone 5, and to get from Zone 2 to Zone 5, is 40 minutes.
Is there any way to do this possible?
I've attached a spreadsheet that does it assuming you know the distances between various zones. (So far as I know, Google or Apple's map apps are the best way to actually calculate the distances.) But if you create a table such as I've shown at the top of this image... and then another table that shows the zones in which each location are to be found.... a single INDEX function, using output from two VLOOKUPs--the latter being triggered by the user's entry of a start point and a destination....will get you the distance or time
I did not go to the length of Protection, since you will want to be able to modify and play with this.
mathetes Thank you A LOT..!
This is just for a kinda statistics, that's the reason we are not using Maps or something.
It really help me way to much!
I'm playing with it. And it was so simple, actually. I mean, I want to see if I can adapt it to my work and present it.
Really, really, thank you!