Formula Question
Posted by Andonny on December 22, 2000 4:14 AM
Hi,
I have this formula =if(A1="Date","5") . I have "Date 15/12/00" in A1 and I would like to have the answer of 5 if part of the cell matches. I think it is called a wild card. I tried a few things but it didn't work for me.
Kind help would be very much appreciated
Andonny
Posted by Dave on December 24, 2000 11:49 AM
Hi Andonny
Try this:
=IF(ISERROR(FIND("Date",A1)),"",5)
Dave
OzGrid Business Applications
