Difficult Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
__
 
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
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top