Search and Display Formula

[koba]

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(D8>D7,"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

[Rowan Drummond]

Maybe:

=IF(ISNUMBER(SEARCH("HD",A8)),IF(D8>D7+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(D8>D7,"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
>
>