# Pass And Fail

1. ## Pass And Fail

Hi Experts,

The Criteria or Acceptance region is 98-102 is Passed, Below 98 = Failed

The formula Im using is

=IF(A1<98,"Failed",IF(A1>98,"Passed",IF(A1>=103,"Failed")))

But I dont have any luck.

Thank you.

thong

2. ## Re: Pass And Fail

Try:

=IF(AND(A1>102,A1<98),"Failed","Passed")

3. ## Re: Pass And Fail

Try tis one (untested)

=if(or(a1<98,a1>103),"Failed","Passed")

4. ## Re: Pass And Fail

=IF(AND(A1>=98,A1<103),"Passed","Failed")

5. ## Re: Pass And Fail

I tried this... IF(And(A1>97,A3<103),"Passed","Failed") and it worked for me.

6. ## Re: Pass And Fail

thong,

The following formula:

``Please Login or Register  to view this content.``
returns PASSED if A1 = 98-102, failed for all other values, and blank/nothing if A1 is empty.

Hope this helps.

7. ## Re: Pass And Fail

Good point well made by BB1972. All three previous solutions work also but when the cell is blank Excel will treat this as 0 and therefore "Failed" will be visible in your formula cell unless you approach this along the lines of BB1972.

8. ## Re: Pass And Fail

Very gracious of you to say so, Harribone Cheers!

9. ## Re: Pass And Fail

Hi All,

Thank you very much. Appreciate it.

Thong

10. ## Re: Pass And Fail

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