Basic Formula Question

[CAW]

I have a formula -- =IF(T2=???,K2,0) -- where I want the '???' to represent any random type of text entered into cell T2 (If T2 equals anything, show K2, else 0). What do I use to replace the '???'?

I tried using "*", but obviously that did not work.

Thanks!

 

[Richard Schollar]

Hi

Try:

=IF(ISNUMBER(SEARCH("*",T2)),K2,0)

Best regards

Richard

 

[pgc01]

Hi CAW

Please try:

=IF(T2<>"",K2,0)

HTH
PGC

 

[CAW]

They both work great, but I'm going to use pgc01's suggestion for simplicity reasons.


Thanks again folks!