Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difficult Formula
A3 is a drop down list of words (Restaurants, Mini-Warehouse, etc)
B2 is a numeric entry ($500,000, $1,000,000, etc) I need B3 to create the following into a formula If A3 is Mini-Warehouse and B2 is $500,000 then B3 is $.22 BUT I need the formula to be able to detect which word I use. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Another difficult failed formula | Excel Worksheet Functions |