+ Reply to Thread
Results 1 to 3 of 3

Difficult Formula

  1. #1
    Cindy
    Guest

    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. #2
    Richard Buttrey
    Guest

    Re: Difficult Formula

    On Thu, 9 Mar 2006 13:39:30 -0800, Cindy
    <[email protected]> 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. #3
    Sandy Mann
    Guest

    Re: 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
    [email protected]
    [email protected] with @tiscali.co.uk


    "Cindy" <[email protected]> wrote in message
    news:[email protected]...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1