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
__
|