Formula Help, Please

[Joe Galvan]

I have this formula;

=IF(ROWS($AT$9:AT9)<=$AT$4,SMALL(IF(Table_Query_from_TDGSADTS[F1ALTF]<=$AT$3,IF(Table_Query_from_TDGSADTS[F1CPND]=0,ROW(Table_Query_from_TDGSADTS[F1ALTF])-ROW($F$2)+1)),ROWS($AT$9:AT9)),"")


I am trying to stick in a listing string, as underlined below;

IF(Table_Query_from_TDGSADTS[F1PTYP]={"L","F"}

I keep getting errors?? I know this type of listing sting can be tempermental in some formulas...

Any Ideas on how to stick something similar into the IF(ROWS function above? It would be inputed as another IF statment in the first formula....



thanks in Advance,
JOE

 

[MrKowz]

I have no idea what your function is doing, or meant to do, but the error might be because you need to wrap that condition in an OR statement:

IF(OR(Table_Query_from_TDGSADTS[F1PTYP]={"L","F"})

 

[T. Valko]

I have this formula;

=IF(ROWS($AT$9:AT9)<=$AT$4,SMALL(IF(Table_Query_from_TDGSADTS[F1ALTF]<=$AT$3,IF(Table_Query_from_TDGSADTS[F1CPND]=0,ROW(Table_Query_from_TDGSADTS[F1ALTF])-ROW($F$2)+1)),ROWS($AT$9:AT9)),"")


I am trying to stick in a listing string, as underlined below;

IF(Table_Query_from_TDGSADTS[F1PTYP]={"L","F"}

I keep getting errors?? I know this type of listing sting can be tempermental in some formulas...

Any Ideas on how to stick something similar into the IF(ROWS function above? It would be inputed as another IF statment in the first formula....



thanks in Advance,
JOE

Try it like this...

IF(ISNUMBER(MATCH(Table_Query_from_TDGSADTS[F1PTYP],{"L","F"},0)))

 

[Joe Galvan]

Mr Knowz... its just one formula in a listing function...



T. Valko...Your addition worked perfectly... THANKS!

 

[T. Valko]

T. Valko...Your addition worked perfectly... THANKS!

You're welcome. Thanks for the feedback!