Results 1 to 5 of 5

Thread: I Keep getting an error for a simple syntax
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2015
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default I Keep getting an error for a simple syntax

    I am using the following formula in a cell and when I input Y into C3 I am getting #Name ? instead of "this is broken"

    What am I doing wrong?

    =IF(C3=Y,"This is broken", "")

    If I change the formula to: =IF(C3=15,"This is broken", "") and put 15 in C3, the cell with the formula reads correctly as "this is broken"

  2. #2
    Board Regular FDibbins's Avatar
    Join Date
    Feb 2013
    Location
    Duncansville, PA USA
    Posts
    6,723
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I Keep getting an error for a simple syntax. Please help

    Try wrapping the Y in ""

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    Regards

    Ford

  3. #3
    Board Regular
    Join Date
    Jul 2007
    Location
    Sydney
    Posts
    4,392
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: I Keep getting an error for a simple syntax. Please help

    Hi Adam,

    The Y has to be in quotes like this "Y" or else Excel thinks it's a function which as there is no Y function it returns #Name?.

    Robert
    Last edited by Trebor76; Nov 17th, 2017 at 06:56 PM.

  4. #4
    New Member
    Join Date
    Oct 2015
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I Keep getting an error for a simple syntax. Please help

    That worked. Thank you both!!

  5. #5
    Board Regular FDibbins's Avatar
    Join Date
    Feb 2013
    Location
    Duncansville, PA USA
    Posts
    6,723
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I Keep getting an error for a simple syntax. Please help

    Happy to help

    All text in a formula needs to be wrapped inside ""

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    Regards

    Ford

Some videos you may like

User Tag List

Tags for this Thread

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
  •