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
Bookmarks