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 |
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 |
All times are GMT +1. The time now is 11:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com