Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
please help (drop down list)
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
please help (drop down list)
Hi,
I don't follow - where do you want the formula, what do you want it to do. Give us a small example. Thanks, Shane Devenshire "tom" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |