# If Statement Help

#### bsteeves

##### Active Member
=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"

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### nbrcrunch

##### Well-known Member
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

##### Active Member
Any ideas on how to go about that?

#### ossuary

##### Active Member
Any ideas on how to go about that?

Try replacing the section that reads Calculator!I4="fsa" with this:
Code:
``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:

Code:
``=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

##### Active Member
Perfect that is exactly what I needed.

Replies
6
Views
303
Replies
17
Views
546
Replies
1
Views
2K
Replies
7
Views
359
Replies
7
Views
537

1,190,767
Messages
5,982,822
Members
439,799
Latest member
matts12

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back