Hey guys
I'm new in excel and i cant figure it out
I'm using excel 2007 i got 2 cells one cell got a scroll bar with lets say 5-6 options and one cell got numbers
i want it to do a different calculation every time (well depends on what i will pick in the scroll cell )
Hi, welcome to the forum
Based on the minimal amount of info provided, it sounds like you need to look at using vlookup() or index/match
If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
hey thanks for the fast reply
i need to do this calculation
1cell:number 2cell: where the calculation will be 3cell: where i got the scroll bar with this options (0-40,0-20,0-80)
if i got in 3cell 0-40 do that in 2cell (1cell\1.4)
if i got in 3cell 0-20 do that in 2cell (1cell\1.2) http://wikisend.com/download/544416/11.xlsx
Can you upload your workbook here please
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
11.xlsx here you go )
Does the attached explain anything about how those drop-downs can be part of a calculation?
The ones you have are text and the RIGHT function strips off the last two numbers. When multiplied by your list of other numbers
it is coerced into its numeric value. The calculations work from there.
the attached do not explain about the drop-downsOriginally Posted by FlameRetired
i will upload another file with examples of the data i need to calculate i think it will be more clearer that way 11.xlsx
OK...try this one.
is it different in ms 2007? coz i get sometimes wrong terraGIS Soil numbers like its fixed on a specific one
in my table the first row it counts like the second one meaning if 0-40 1.2
0-20 1.3
when i pick 0-40 i get 1.3
I suggest you create a small table with your criteria and their values...
terraGIS Soil 0-20 0-40 40-70 0-80
Then you can use this, copied down, for the calc...
=D2/VLOOKUP(F2,$J$2:$K$5,2,0)
You can still use the Drop-down (thats's what it is called) in column F
Re: different calculation every time depends on what i will pick in the scroll cell
thanks i will try this out and let you know
guys thx again for the help and the very fast reply
Looking forward to hearing from you soon
guys sorry for the late reply i got it
i had a problem with the order of thing (1,2,3,4,5 ...) now i know that vlookup wants everything to be ordered
also with the cell format but got it
anyway guys thanks again for all the help
You're welcome. Glad it helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks