Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search and Display Formula
Hi Could somebody please help me develop a formula for the following problem? I have a formula which some nice person here developed for me =IF(ISNUMBER(SEARCH("HD",A8)),IF(D8D7,"GOOD","BAD "),"NOT HD") But now I need to extend on it. What I need is if A8 contains HD and D8 is greater than D7 by $50 display “GOOD” otherwise display “BAD”. Otherwise if there is no HD display NOT HD 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=483696 |
#2
|
|||
|
|||
Search and Display Formula
Maybe:
=IF(ISNUMBER(SEARCH("HD",A8)),IF(D8D7+50,"GOOD"," BAD"),"NOT HD") Regards Rowan koba wrote: Hi Could somebody please help me develop a formula for the following problem? I have a formula which some nice person here developed for me =IF(ISNUMBER(SEARCH("HD",A8)),IF(D8D7,"GOOD","BAD "),"NOT HD") But now I need to extend on it. What I need is if A8 contains HD and D8 is greater than D7 by $50 display “GOOD” otherwise display “BAD”. Otherwise if there is no HD display NOT HD Please help Much Appreciated Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
How do I display the RESULT of a formula | New Users to Excel | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
Search and Display Sheet Name | Excel Discussion (Misc queries) | |||
Search within formula | Excel Worksheet Functions |