wild card with if logical function

[b166er]

hi members,

i need help on how to use wild cards(*/?) with if logical
function is it possible to use with if logical function if yes please
just tell me how to use wild cards dont tell me alternative functions.

 

[Biff]

Hi!

wild cards...is it possible to use with if logical function

No, not directly. They would have to be used in nested functions that accept
wildcards as part of the logical test.

dont tell me alternative functions

OK

Biff

 

[Ardus Petus]

are COUNTIF and SUMIF "alternative" functions?
They accept wildcards.

HTH