Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a complicated formula
I know what I want to do but I don't know how to do it.
I have a cell with a drop down list and I need the cell next to it to be able to tell which word I pick and then enter a correct number for that particular word. Example A3 - Restaurant, Mini-Warehouse, Etc B2 - $500,000 B3 needs to say if A3 says Mini-Warehouse @ B2 equals $.22 Is this possible????? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a complicated formula
You have a suggestion in your other post.
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Cindy" wrote in message ... I know what I want to do but I don't know how to do it. I have a cell with a drop down list and I need the cell next to it to be able to tell which word I pick and then enter a correct number for that particular word. Example A3 - Restaurant, Mini-Warehouse, Etc B2 - $500,000 B3 needs to say if A3 says Mini-Warehouse @ B2 equals $.22 Is this possible????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding something to a complicated formula | Excel Discussion (Misc queries) | |||
Complicated formula not working in 97 | Excel Discussion (Misc queries) | |||
how to create formula to divide two rows autoaatically | New Users to Excel | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions |