Results 1 to 5 of 5

How do i stop if function returning a number which contains the same digit?

Threaded View

KWarlock How do i stop if function... 02-13-2012, 01:08 AM
Paul Re: How do i stop if function... 02-13-2012, 01:51 AM
KWarlock Re: How do i stop if function... 02-13-2012, 02:17 AM
Paul Re: How do i stop if function... 02-13-2012, 02:42 AM
KWarlock Re: How do i stop if function... 02-13-2012, 02:57 AM
  1. #1
    Registered User
    Join Date
    02-13-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    How do i stop if function returning a number which contains the same digit?

    Am using the formula:

    =IF(ISNUMBER(SEARCH("3",H5)),"COLLECT"," ")

    to return the text COLLECT in ,say, I5 if a 3 is input in H5. It seems that if a 13 or 23, or any number containing 3, is input in H5 then COLLECT also appears when I only want it to show COLLECT when 3 is used? Can anyone help please?
    Last edited by KWarlock; 02-13-2012 at 02:59 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1