Results 1 to 15 of 15

Formula error

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Formula error

    Dear friends,
    In cell ‘BE8’ I want to insert this formula but it is giving error ‘missing parentheses. It’s a result sheet and the terms are as follows:

    If the student is fail in 1 subject (<35) then the remark should be ‘F1’
    If the student is fail in 2 subject (<35) then the remark should be ‘F2’
    If the student is fail in 3 subject (<35) then the remark should be ‘F3’
    If the student is fail in 4 subject (<35) then the remark should be ‘F4’
    If the student is fail in 5 subject (<35) then the remark should be ‘F5’
    If the student is fail in 6 subject (<35) then the remark should be ‘F6’

    The formula is:

    =countif(IF(AND(j8 < 35, n8 < 35, r8 < 35, v8 < 35, z8 < 35, ad8 < 35=1, "F1", countif(IF(AND(j8 < 35, n8 < 35, r8 < 35, v8 < 35, z8 < 35, ad8 < 35=2, "F2", countif(IF(AND(j8 < 35, n8 < 35, r8 < 35, v8 < 35, z8 < 35, ad8 < 35=3, "F3", countif(IF(AND(j8 < 35, n8 < 35, r8 < 35, v8 < 35, z8 < 35, ad8 < 35=4, "F4", countif(IF(AND(j8 < 35, n8 < 35, r8 < 35, v8 < 35, z8 < 35, ad8 < 35=5, "F5", countif(IF(AND(j8 < 35, n8 < 35, r8 < 35, v8 < 35, z8 < 35, ad8 < 35=6, "F6", "P all")
    Please suggest me a correction.

    Thanking you.

    Sincerely,

    Mukesh
    Last edited by mukeshbaviskar; 04-06-2014 at 07:17 AM. Reason: Add code tag

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Inputbox error message. Formula you typed contains an error.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-09-2013, 02:25 PM
  2. [SOLVED] Formula Error-Error Message
    By Paige in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2006, 04:15 PM
  3. Replies: 4
    Last Post: 03-24-2006, 07:20 AM
  4. [SOLVED] Error values:DIV/0! error in SumProduct formula with no division
    By Jerry W. Lewis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM
  5. [SOLVED] Formula error with Mac resulting in '#NAME' error
    By Linking to specific cells in pivot table in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2005, 03:05 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