Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 -- koba ------------------------------------------------------------------------ koba's Profile: http://www.excelforum.com/member.php...o&userid=28639 View this thread: http://www.excelforum.com/showthread...hreadid=483024 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |