LinkBack URL
About LinkBacks
I want a cell to out put for example (if volume is xx.xx then count equals xx.xx) How do I do this? I have never programmed in excel before.
Conditional Clauses
I want a cell to out put for example (if volume is xx.xx then count equals xx.xx) How do I do this? I have never programmed in excel before.
Hi and welcome to the forum
Your request (to me at least) is unclear, sorry. Could you give more detail, and perhaps give a few examples of your data and a few samples of your expected outcome?
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
If Volumetric = <0.1m3 (3ft3) then use 5 sensors
If Volumetric = 0.1m3 - 8.5m3 (3ft3 - 300ft3)then use 9 sensors
If Volumetric = 8.5m3 - 11.5m3 (300ft3 - 405ft3) then use 10 sensors
etc...
I want a drop down list of the different volumes to select from.
When I select the desired volume I want another cell to populate the amount of sensors required for the selected volume.
Later I wouldlike to link to this out put when recording test result it will expect 9 sensor readings if that was my original selection and will not allow me to proceed untill all 9 test results are filled in their respected cells.
Is this possible?
Im sure we can come up with something (sounds like a vlookup(), however, i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
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.
Here is an example file let's work with this?
Take a look at the attached. I used a vlookup(), but changed your combo box to a regular drop-down
Re: Conditional Clauses
@FDibbins Thanks this helped out alot.
Can you explain to me step by step the process you took to achieve this? Yes i know I am the ultimate novice.
Thanks.
Sure, no problem
1st, I moved your combo box out of the way, its not needed here (you can delete if you want)
2. select D3, click Data tab/data validation, select list, select source, and then highlight A7:A15/OK
3. in D4, copy this...
=VLOOKUP($D$3,A7:H15,8,0)
This will search for the contents of D4 in A7:A15, and then return the contents of the 8th column.
An alternative, using your combo-box, would be to right-click into it, select Format Control, under Cell Link, click on D4
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks