+ Reply to Thread
Results 1 to 4 of 4

Formula error_no correct output

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

    Formula error_no correct output

    Deleted. Problem solved.
    Attached Files Attached Files
    Last edited by mukeshbaviskar; 04-18-2014 at 08:46 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,957

    Re: Formula error_no correct output

    Not sure I understand your problem?

    The formula and the "required" match in rows 12, 13 and 14, and your formula is testing for "A" in the row, row 13 has A's, so the answer is A. Can you explain to me why you think it should not be A?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

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

    Re: Formula error_no correct output

    There are 5 'A' in row 13. That means the student is absent in 2 subjects for first and second semester and absent in 1 semester loosing 7.5 points in column 'an'. So the output should be 19.5 instead of 'A'.

    Now I changed the formula and solved the problem.

    Hope this clear your doubt of row 13 output.

    Thank you.

    Regards,

    Mukesh

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Formula error_no correct output

    If you problem is solved, please mark your thread as solved.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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] Formula not giving correct output
    By aakhan2011 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-24-2014, 03:21 AM
  2. No correct output
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-27-2014, 11:40 PM
  3. [SOLVED] Not getting correct output problem
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-19-2014, 08:44 AM
  4. [SOLVED] Error in sum formula not correct output
    By mukeshbaviskar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2014, 11:40 AM
  5. [SOLVED] Not getting correct output value( Label & (i-6) & .Top)
    By annpricks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2012, 03:44 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