Automatic Display of text

Little Master · Oct 20, 2005

Hi
I want to know the formula for, If i enter *_Any__ * text or numbe
in cell B1 the cell A1 automatically displays this "To"

Biff · Oct 20, 2005

Hi!

Enter this formula in A1:

=IF(B1<>"","To","")

Biff

"Little Master" <[email protected]>
wrote in message
news:[email protected]...

Little Master · Oct 20, 2005

Thanks,

Thanks Biff thanks alot.