+ Reply to Thread
Results 1 to 2 of 2

How to put formula for two different subject's passing marks

  1. #1
    Registered User
    Join Date
    08-13-2016
    Location
    NAGPUR
    MS-Off Ver
    MS OFFICE 2007
    Posts
    49

    Post How to put formula for two different subject's passing marks

    Respected Sir,

    There is a Group of subject in the marksheet, which one subject contains only "Theory"(Passing Marks=32) and "Internal"(Passing Marks=8) marks
    and another subject in the marksheet, which contains "Theory"(Passing Marks=20), "Internal"(Passing Marks=8) & "Practical"(Passing Marks=12) marks

    I used the following formula for the result for the subject which contains only "Theory"(Passing Marks=32) and "Internal"(Passing Marks=8) marks
    =IF(OR(COUNT(G2:H2)=0,AND(G2<32,H2<8)),"",IF(AND(OR(G2<32,ISTEXT(G2)),H2>=8),"P",IF(AND(G2>=32,OR(H2<8,ISTEXT(H2))),"T",IF(AND(G2>=32,H2>=8),"F"))))
    And it is showing the PERFECT RESULT...

    Then How can I insert the another formula for the result IN THE SAME CELL EITHER contains "Theory"(Passing Marks=32) and "Internal"(Passing Marks=8) OR contains "Theory"(Passing Marks=20), "Internal"(Passing Marks=8) & "Practical"(Passing Marks=12) marks

    Thanks in advance..
    Last edited by vijubhau; 01-18-2018 at 12:09 AM.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to put formula for two different subject's passing marks

    can you put together a sample? manually?

+ 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: 17
    Last Post: 01-12-2018, 12:57 PM
  2. [SOLVED] Help comparing two files by subject+Date, subject+DatePlus1, Subject+DateMinus1
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-11-2017, 07:37 AM
  3. Replies: 17
    Last Post: 10-14-2014, 08:21 AM
  4. Best of five within six subject with different out of marks
    By lokvan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2013, 01:53 PM
  5. Best of five within six subject with different out of marks
    By lokvan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2013, 06:22 AM
  6. [SOLVED] Passing a function from VB with text strings in quotation marks
    By Max in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2006, 10:10 AM
  7. [SOLVED] Passing string arguments that have quotation marks in them
    By Caro-Kann Defence in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2005, 11:06 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