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

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