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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difficult Formula
On Thu, 9 Mar 2006 13:39:30 -0800, Cindy
wrote: 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. =If(and(A3="Mini-Warehouse",B2=500000),.22,"Not Mini-Warehouse and $500000") You didn't say what the default is, so just change the last bit as appropriate. HTH Richard Buttrey __ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difficult Formula
You don't say what the tie-up is between the word in A3 and the amount in
B2. To select a value based on the word in A3 try something like: =CHOOSE(MATCH(A3,{"Restaurant","Mini-Warehouse","Etc"},0),100,22,200) -- HTH Sandy with @tiscali.co.uk "Cindy" wrote in message ... 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. |
Reply |
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 |