PC Review


Reply
Thread Tools Rate Thread

adding a formula to items in a drop down list

 
 
tom
Guest
Posts: n/a
 
      25th Nov 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding items on an existing drop-down list =?Utf-8?B?S3VtaWtvMTc=?= Microsoft Excel Misc 1 14th Nov 2006 03:19 PM
Re: Adding items on an existing drop-down list Raffael Microsoft Excel Misc 0 14th Nov 2006 01:43 PM
Formula to total items from a drop list with values in several col =?Utf-8?B?UmVzY3VlcyBNaXR0ZW5z?= Microsoft Excel Misc 1 30th Jul 2005 01:17 AM
Drop-down List where items in drop-down list hyperlink to a webpage? gully Microsoft Word New Users 4 24th Apr 2005 09:58 AM
Adding extra items to a drop down list pitcher17 Microsoft ASP .NET 4 19th Apr 2004 11:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:24 AM.