If Statement Help

[bsteeves]

=IF(AND(C3<>"p",E3="no bid",F3="no bid",G3="no bid",Calculator!I4="fsa",Ratings!Y3<>"P"),Calculator!Y4+Inputs!$I$4,"NO BID")

Now for the I4 part of the formula I need it be any combination of FSA. For example if the formula would be true if the cell = "Fsa st aid"

Thanks in advance

 

[nbrcrunch]

if the "fsa" will always be the first 3 characters, you could use LEFT(i4,3)="fsa"

if it could be anywhere in the string, you'll need to use FIND or SEARCH coupled with >0

 

[bsteeves]

Any ideas on how to go about that?

 

[ossuary]

Any ideas on how to go about that?

Try replacing the section that reads Calculator!I4="fsa" with this:

ISERROR(FIND("fsa",Calculator!I4))=FALSE

Make sure you still have the comma before and after it so the rest of the and statement is correct.

So the full item should read:

=IF(AND(C3<>"p",E3="no bid",F3="no bid",G3="no bid",ISERROR(FIND("fsa",Calculator!I4))=FALSE,Ratings!Y3<>"P"),Calculator!Y4+Inputs!$I$4,"NO BID")

Let me know if that works.

 

[bsteeves]

Perfect that is exactly what I needed.