Thread
:
Difficult Formula
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
Posts: n/a
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 With Quote