Formula

Joined
Sep 30, 2013
Messages
1
Reaction score
0
I'm working on creating an excel to speed up a procedure that I am required to do on a daily basis.

I am simply looking to create a drop list, and be able to give each selection a different value.

Essentially, I work with numbers in decimal feet, and that's what I need to computed value to read.

I will be using Subtracting Column C from Column B, However i need Column C to be a drop down list that reads.

1/2"
3/8"
5/8"

But the value should be in decimal feet, ex.

.041667
.03125
.05208



The sum will be displayed in Column E.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top