wildcard in if statement

[BradM]

Hello, I am having trouble with excel accepting a wildcard in my if statement. The statement works if I remove the wildcard.

here is the statement:

=IF(B:B=6*,IF(E:E<=2,"small","big"),null)

Thanks,
Brad

 

[IML]

What are you trying to accomplish? It is unclear as you are referencing entire columns. Is it is anything in the column B starts with 6, and if any number is less than two in e?

 

[BradM]

That exactly what I am trying to do.

The end result I am working for is to have totals lengths created from a list. The criteria are size, code and length. For example one is The total length based on all codes starting with 6 and are 2" or larger .

I would like to do a sumif but cannot figure out the wildcard.

Thanks for your help.

 

[Zack Barresse]

Hi,

Maybe ..

=SUM(IF(LEFT(B1:B100,1)="6",B1:B100))

Where B1:B100 is your range. Do not use an entire column, do not place formula in column B, or range in formula. Conform with Ctr + Shift + Enter, not just Enter, as it's an array formula.

Does it help?

 

[BradM]

does left mean the character on teh left in the cell

 

[Zack Barresse]

does left mean the character on teh left in the cell

Yes. The specified number of characters you have in the second syntax of the function.