+ Reply to Thread
Results 1 to 4 of 4

Missing parenthesis or too many argument on a formula

  1. #1
    Registered User
    Join Date
    05-05-2014
    Location
    Voorheesville, NY
    MS-Off Ver
    Excel 2007
    Posts
    72

    Missing parenthesis or too many argument on a formula

    Hi,
    Excel is telling me that my formula listed below, is missing a parenthesis--) or (.Check the formula, and then add the parenthesis in appropriate place.

    Please Login or Register  to view this content.
    If the formula, has too many argument, is there something I can do to make this formula works?

    Cheryl
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Missing parenthesis or too many argument on a formula

    Hi,

    Please try the following:

    =IFERROR(IF(OR(B3=B2,B3=B4),"x",IF(OR(AND(B3=B4,C3=C4),AND(B3=B2,C3=C2)),"")),"")

  3. #3
    Registered User
    Join Date
    05-05-2014
    Location
    Voorheesville, NY
    MS-Off Ver
    Excel 2007
    Posts
    72

    Re: Missing parenthesis or too many argument on a formula

    Hi cbatrody,

    Thank you for the formula...with slight modification...it work like a charm
    =IFERROR(IF(OR(B2=B1,B2=B3),"x",IF(OR(AND(B2=B1,C2=C1),AND(B2=B3,C2=C3)),"")),"")

    Thank you again!

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Missing parenthesis or too many argument on a formula

    You are welcome

    If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] "Your Formula Missing a Parenthesis"
    By xrajncajnx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 01:03 PM
  2. [SOLVED] IF statement missing parenthesis in formula
    By Abyrose in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2014, 06:24 PM
  3. [SOLVED] Formula missing parenthesis
    By katieshields in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2014, 03:44 AM
  4. [SOLVED] Missing an argument?
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-23-2012, 11:58 AM
  5. Missing parenthesis
    By docrobo in forum Excel General
    Replies: 3
    Last Post: 10-23-2011, 05:18 PM

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