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

1. ## 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=" "

2. ## 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","")))

3. ## 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",""))))))

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

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. ## 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..??

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

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

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

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

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

#### 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