Results 1 to 4 of 4

Need formula for Group Exemption from Theory, Internal & Practical

Threaded View

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

    Lightbulb Need formula for Group Exemption from Theory, Internal & Practical

    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..
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 01-10-2018, 01:31 AM
  2. [SOLVED] Theory Post: Array Formula Troubleshooting
    By The_Snook in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-02-2017, 01:49 PM
  3. Theory Post: Check for formula changes between two workbooks
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-13-2016, 03:21 AM
  4. Internal Rate of Return Formula
    By eslee32 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2016, 03:39 PM
  5. [SOLVED] Allow exemption when Prevent Duplicate is Applied
    By jap5lap in forum Excel General
    Replies: 10
    Last Post: 12-22-2014, 08:33 PM
  6. [SOLVED] MATRICES ISSUE: Trouble translating some geographical matrix theory into a formula
    By spanishguy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2012, 01:50 PM
  7. [SOVED]erasing all worksheets with exemption
    By burugudug in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-29-2010, 02:42 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