Help with formula - IF statement

[easybpw]

Hi everyone,

Thanks in advance for all the great help. I created the formula below and it works like it should. However I need to tweak it and don't have a clue how to do that.

=IFERROR(IF(S7="P&L Expense","Deposit Variance"&" "&RIGHT(Q7,10),"Change Order"&" "&RIGHT(Q8,10)),"")

What I need to say is this: If E7 CONTAINS "3742" then ignore everything above and the result should be "No Cash Sale". If E7 doesn't contain "3742" then do the formula above. Perhaps there's an easier way to write the formula above as well but I'm not sure.

Again thanks for all the assistance!

 

[Fluff]

How about

=IF(ISNUMBER(FIND("3742",E7)),"No Cash Sale",IF(S7="P&L Expense","Deposit Variance"&" "&RIGHT(Q7,10),"Change Order"&" "&RIGHT(Q8,10)))

 

[AlanY]

try this

=IF(ISNUMBER(SEARCH(3742,E7)),"No Cash Sale",IFERROR(IF(S7="P&L Expense","Deposit Variance"&" "&RIGHT(Q7,10),"Change Order"&" "&RIGHT(Q8,10)),""))

 

[Micron]

IFERROR(IF(E7=3742, "NO CASH SALE",IF(S7="P&L Expense","Deposit Variance"&" "&RIGHT(Q7,10),"Change Order"&" "&RIGHT(Q8,10)),"")

assumes 3742 is a number and not text.