View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cindy
 
Posts: n/a
Default 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.