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
Bookmarks