Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Why can't I use * in formula?

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Hong Kong
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello guys, I would like to set a formula to search the remark field that contains the word "pass", but I found out I could not use * in the IF formula, can anyone help me?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    "*" is Excels multiplication symbol?

    James

  3. #3

    Join Date
    Apr 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 18:34, gresple wrote:
    Hello guys, I would like to set a formula to search the remark field that contains the word "pass", but I found out I could not use * in the IF formula, can anyone help me?
    The wild card character * for any sequence of characters (or ? for any single character) can be used in the SEARCH funtion.
    What are you trying to do?

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 18:34, gresple wrote:
    Hello guys, I would like to set a formula to search the remark field that contains the word "pass", but I found out I could not use * in the IF formula, can anyone help me?
    No, to my knowledge, you can not use a wildcard in the IF function.

    Regards!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Provide a precise problem statement, sample data, and expected results.

  6. #6
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try:

    =IF(ISERR(FIND("PASS",C4,1)>0),"your message or action if pass is not found","your message if pass is found")
    This looks for the text PASS in C4 beginning a the first character and returns the position in the string where it found it. It returns an error if it is not found, thus the ISERR

    You can remove the quotes is you want a number entered in the cell instead.

    Forgot to mention that the "PASS" is case-sensitive.

    [ This Message was edited by: klb on 2002-05-09 10:17 ]

  7. #7
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Forgot to mention that the "PASS" is case-sensitive.

    Hi klb:
    Just to extend your point a little further, one can use the SEARCH function instead of FIND -- since SEARCH is not case sensitive.

    Regards!

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  8. #8
    New Member
    Join Date
    Apr 2002
    Location
    Hong Kong
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you very much klb!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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