Search and Display Formula

  • Thread starter Thread starter koba
  • Start date Start date
K

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
 
Maybe:

=IF(ISNUMBER(SEARCH("HD",A8)),IF(D8>D7+50,"GOOD","BAD"),"NOT HD")

Regards
Rowan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Formula 1
formula help 4
Copy Formula Question 2
How to search for nearest nonblank cell in previous rows? 8
alternative formula for VLOOKUP since it stops with the 1st value itself 2
Formula error - IF(AND... 3
formula copying without confirming possible? 2
Easy formula question 3

Back
Top