We've Moved! Visit our NEW FORUM to join the latest discussions. This is an archive of our previous conversations...

You can find the login page for the old forum here.
CHATPRIVACYDONATELOGINREGISTER
DMT-Nexus
FAQWIKIHEALTH & SAFETYARTATTITUDEACTIVE TOPICS
Need programming (or excel) help - Simple drop down menu calculator Options
 
endlessness
#1 Posted : 6/21/2016 2:26:11 AM

DMT-Nexus member

Moderator

Posts: 14191
Joined: 19-Feb-2008
Last visit: 15-Nov-2024
Location: Jungle
Hello,

Any programmers out there or people who know about excel?

I need help with a calculator im building to help identifying substance spots on a TLC plate (you dont need to know what that is to help Very happy )

I have a simple excel Im attaching.

All I need is that instead of cell D2 which says Known Substance, it becomes a drop down list so you can select any of the substance names on column A, and that cell E2 shows the accompanying ratio from column B.
Same for cell D4/unknown substance, it should be any of the corresponding names

And then the user will just have to add a number on cell d3 and it will automatically calculate the unknown substance height on cell E5

If anybody knows how to do this in excel, or want to set up some online calculator or an app or really any other method that makes a working calculator for this data set, that'd be amazing Smile

Thank you very much in advance!
 

Good quality Syrian rue (Peganum harmala) for an incredible price!
 
Thistle Elf
#2 Posted : 6/21/2016 8:57:57 AM

DMT-Nexus member


Posts: 60
Joined: 24-Oct-2015
Last visit: 17-Apr-2022
Hi

I did a little bit of magic with my small excel skills.
Is this what you are looking for or should it be changed a little bit?
Hope it helped
Disclaimer: Everything I say/write/post/think about is fiction. All said activities are intended for educational or entertainment purposes only.
 
endlessness
#3 Posted : 6/21/2016 11:05:24 AM

DMT-Nexus member

Moderator

Posts: 14191
Joined: 19-Feb-2008
Last visit: 15-Nov-2024
Location: Jungle
Thank you so much, that is perfect!!
 
 
Users browsing this forum
Guest

DMT-Nexus theme created by The Traveler
This page was generated in 0.011 seconds.