+ Reply to Thread
Results 1 to 2 of 2

Your Formula missing parenthesis--) or (.check the formula and then add parenthesis

  1. #1
    Registered User
    Join Date
    04-10-2016
    Location
    india
    MS-Off Ver
    2010
    Posts
    1

    Exclamation Your Formula missing parenthesis--) or (.check the formula and then add parenthesis

    I want to work using If formula as alternative, however formula work upto w column only, while using X column errors appeared as " Your formula missing parenthesis--) "

    Formula is....
    (IF(H2=I2,I5,(IF(H2=J2,J5,(IF(H2=K2,K5,(IF(H2=L2,L5,(IF(H2=M2,M5,(IF(H2=N2,N5,(IF(H2=O2,O5,(IF(H2=P2,P5,(IF(H2=Q2,Q5,(IF(H2=R2,R5,(IF(H2=S2,S5,(IF(H2=T2,T5,(IF(H2=Q2,Q5,(IF(H2=U2,U5,(IF(H2=V2,V5,(IF(H2=W2,W5,(IF(H2=X2,X5,0))))))))))))))))


    Please help me out to resolved the issue

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,148

    Re: Your Formula missing parenthesis--) or (.check the formula and then add parenthesis

    This ..

    =IF(H2=I2,I5,IF(H2=J2,J5,IF(H2=K2,K5,IF(H2=L2,L5,IF(H2=M2,M5,IF(H2=N2,N5,IF(H2=O2,O5,IF(H2=P2,P5,IF(H2=Q2,Q5,IF(H2=R2,R5,IF(H2=S2,S5,IF(H2=T2,T5,IF(H2=Q2,Q5,IF(H2=U2,U5,IF(H2=V2,V5,IF(H2=W2,W5,IF(H2=X2,X5,0)))))))))))))))))

    OR

    =INDEX($I$5:$X$5,MATCH($H$2,$I$2:$X$2,0)) ?????

+ 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. Replies: 5
    Last Post: 09-01-2015, 09:06 PM
  2. [SOLVED] Missing parenthesis or too many argument on a formula
    By dache416 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2014, 01:15 PM
  3. [SOLVED] "Your Formula Missing a Parenthesis"
    By xrajncajnx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 01:03 PM
  4. [SOLVED] IF statement missing parenthesis in formula
    By Abyrose in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2014, 06:24 PM
  5. [SOLVED] Formula missing parenthesis
    By katieshields in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2014, 03:44 AM
  6. Missing parenthesis
    By docrobo in forum Excel General
    Replies: 3
    Last Post: 10-23-2011, 05:18 PM
  7. Series in parenthesis of formula
    By andersb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-12-2011, 04:41 AM

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