+ Reply to Thread
Results 1 to 2 of 2

Help with Formula

  1. #1
    Registered User
    Join Date
    11-07-2005
    Posts
    45

    Help with Formula

    Hi

    Could somebody please help me develop a formula for the following problem

    If cell A3 contains the letters HD and the price in cell D3 is lower than the price in D2 display “BAD PRICE” other wise display “OK”. Otherwise display “NOT HD” if the letters hd are not in the cell.

    The references in the A cells will contain both letters and numbers such as:
    9000
    9000HD
    9000HDB
    9151
    9151HD

    Please help

    Much Appreciated

    Andrew

  2. #2
    RagDyer
    Guest

    Re: Help with Formula

    Try this:

    =IF(ISNUMBER(SEARCH("HD",A3)),IF(D3<D2,"BAD PRICE","OK"),"NOT HD")

    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================


    "koba" <[email protected]> wrote in message
    news:[email protected]...
    >
    > Hi
    >
    > Could somebody please help me develop a formula for the following
    > problem
    >
    > If cell A3 contains the letters HD and the price in cell D3 is lower
    > than the price in D2 display "BAD PRICE" other wise display "OK".
    > Otherwise display "NOT HD" if the letters hd are not in the cell.
    >
    > The references in the A cells will contain both letters and numbers
    > such as:
    > 9000
    > 9000HD
    > 9000HDB
    > 9151
    > 9151HD
    >
    > Please help
    >
    > Much Appreciated
    >
    > Andrew
    >
    >
    > --
    > koba
    > ------------------------------------------------------------------------
    > koba's Profile:

    http://www.excelforum.com/member.php...o&userid=28639
    > View this thread: http://www.excelforum.com/showthread...hreadid=483024
    >



+ 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