Greetings
Does any one know how to wild card the 3's in "3/0/3/0" for the following formula?
=IF(A1="3/0/3/0",0,"")
Greetings
Does any one know how to wild card the 3's in "3/0/3/0" for the following formula?
=IF(A1="3/0/3/0",0,"")
Last edited by NBVC; 12-02-2010 at 03:15 PM.
So you want 0 if you have the pattern of n/0/n/0 where n is a digit? If so,
=IF(ISNUMBER(SEARCH("?/0/?/0",A1)),0,"")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Perhaps something like this:
Is that something you can work with?Please Login or Register to view this content.
Both Suggestions work perfectly. Thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks