+ Reply to Thread
Results 1 to 7 of 7

Need Exact Excel formula for Pass Fail or Exemption in Subject if Cell contains Text Value

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

    Exclamation Need Exact Excel formula for Pass Fail or Exemption in Subject if Cell contains Text Value

    Respected Experts,

    as shown below in my excel file the Cell E & F contains the value in Number and Text
    and there is formula in Cell H for the Result..

    ..... E..... F...... H.....
    1.... 32....08.... "F"
    2.... 31....08.... "P"
    3.... 32....07.... "T"
    4.... 31....07.... " "
    5.... AA....08.... "P"
    6.... 32....AA.... "T"
    7.... AA....AA.... " "

    BUT....
    As shown above in the Cell 'H' I need the value that,
    if Cell E1 is greater than or equal to 32 and F1 is greater than or equal to 08, then show H1="F";
    if Cell E1 is less than 32 and F1 is greater than or equal 08, then show H1="P";
    if Cell E1 is greater than or equal to 32 and F1 is less than 08, then show H1="T";
    if Cell E1 is less than 32 and F1 is less than 08, then show H1=" "
    so also if either E1 or F1 cell is contains Text value then result must be shown as;
    if Cell E1 is Text value and F1 is greater than or equal 08, then show H1="P";
    if Cell E1 is greater than or equal to 32 and F1 is Text Value, then show H1="T";
    and if both cell contains Text Value than H1=" "

    Thanks in advance...
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,136

    Re: Need Exact Excel formula for Pass Fail or Exemption in Subject if Cell contains Text V

    hi there. try:
    =IF(AND(OR(E2<32,ISTEXT(E2)),F2>=8),"P",IF(AND(E2>=32,OR(F2<8,ISTEXT(F2))),"T",IF(AND(E2>=32,F2>=8),"F","")))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,235

    Re: Need Exact Excel formula for Pass Fail or Exemption in Subject if Cell contains Text V

    bunch of ways to do this, here is 1...
    =IF(AND(ISTEXT(E2),F2>=8),"P",IF(AND(ISTEXT(F2),E2>=32),"T",IF(AND(E2<32,F2<8),"",IF(AND(E2>=32,F2>=8),"F",IF(AND(E2<32,F2>=8),"P",IF(AND(E2>=32,F2<8),"T",""))))))
    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

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

    Re: Need Exact Excel formula for Pass Fail or Exemption in Subject if Cell contains Text V

    Thanks for your help Sir..

    But it's not working properly.. B'coz if both the cell contains TEXT Value then the result is showing as "P" not " "..

    But thanks.. I will definitely work with this formula...

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

    Re: Need Exact Excel formula for Pass Fail or Exemption in Subject if Cell contains Text V

    Thanks for your valuable help Sir..

    But it's not working properly.. B'coz if both the cell contains TEXT Value then the result is showing as "P" not " "..

    It is working up to either E1 or F1 contains Text Value...

    But if both the CELLS contains Text Value then it is not Showing the Result as " "..

    What to do Sir..??
    Last edited by vijubhau; 01-09-2018 at 11:23 PM.

  6. #6
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,136

    Re: Need Exact Excel formula for Pass Fail or Exemption in Subject if Cell contains Text V

    maybe:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

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

    Re: Need Exact Excel formula for Pass Fail or Exemption in Subject if Cell contains Text V

    Excellent sir.. Now this formula is working.....

+ 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. NEED value of PASS or FAIL in another cell
    By vijubhau in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-05-2018, 12:52 AM
  2. Formula Help with Pass/Fail function
    By bna1219 in forum Excel General
    Replies: 1
    Last Post: 12-10-2014, 09:57 AM
  3. Replies: 1
    Last Post: 10-22-2014, 08:32 AM
  4. [SOLVED] Need help with formula to return value of Pass or Fail
    By bearligirl89 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-15-2013, 01:06 PM
  5. [SOLVED] Need a formula for pass/fail based on no. of Y answers but automatically fail if 3a is N
    By Researcher1111 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-15-2013, 10:20 PM
  6. text value pass or fail
    By wykoems in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2013, 08:41 AM
  7. Help with Pass / Fail Formula
    By milovisk in forum Excel General
    Replies: 4
    Last Post: 03-20-2012, 02:57 PM

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