Help with Formula

  • Thread starter Thread starter koba
  • Start date Start date
K

koba

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
 
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!
==============================================
 

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

Similar Threads

Deleting lines that use them for formulas 4
Search and Display Formula 1
Cell Formula 2
Counting Upper and Lower case chars in a Cell 7
What makes people want to buy this NetBook 2
Excel Use COUNTIF across a range of cells with formulas 0
reference format and column name 1
Formula Help 2

Back
Top