adding a formula to items in a drop down list

T

tom

Hello,
I am wondering if anyone can help adding a formula to a text cell of a drop
down list. I understand how to generate a drop down list, however I am stuck
on the formula.
This is the best way i can explain it:

The text is the drop down list might be
- a pinch
- a hand full
- a shovel full
- a wheel barrow full

Each amount has a formula with the amount in ounces or pounds that would
auto sum in a total column. I hope I explained i properly. Any help would be
greatly appreciated.

PS I know I can do it by adding another row but I would like it included in
the down list. Thanks.
 

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

Similar Threads

How to make repeating drop-down lists? 2
please help (drop down list) 1
Drop down list control value in vba 2
Link a text box based on drop down box with four options MS Word 365 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Filtered drop down list 2
Using Drop Down list to an If Statement to another Drop Down list 3
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1

Top