Wildcard in IF Function

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Is there anyway to use a wildcard in the logical test
portion of the IF function. I have tried using an
asterisk similar to filtering but can not seem to get it
to work. Any help would be appreciated.

Thanks,
Phil
 
It's not really a "wildcard" per se, but you can use a helper cell
(X1).......

=if(A1=$X$1,dadadada,dededede)........then you can change X1 at will to
change the formula in a lot of cells......

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top