| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Perform calculation from drop down list
I have a drop down list containing 5 currencies, I choose a currency e.g USD
my worksheet will total the amounts in USD. From this total I require a further cell which will convert this total into Euros but the cell must also be able to convert any of the five chosen currencies List output USD Total 900 USD Total Euros?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
| How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| Drop Down List | Excel Worksheet Functions | |||
Linear Mode
