Help with IF Function

[ANAND KUMAR]

Dear All,

I need some help on IF function. I have a sheet in below format In the Overall results (2nd Image) section ,I want another formula to calculate pass, needed attention and fail ,this should be done by dividing sample size by errors identified

For ease attaching file herewith,

https://www.sendspace.com/file/gcs2o2


Any help would be appreciated.

 

[ANAND KUMAR]

Can someone help on this pls.

 

[Michael M]

Looks like this example needs to be downloaded.....a lot of users won't do that !!
Can you simply post a SMALL sample of your data here !!

 

[ANAND KUMAR]

Thanks for reply. That's why I attached Images as well.

No.

Attribute Tested

Risk Group

Sample Size

SAMPLE Policy #123456 Sept 14, 2016

Sample #1 Policy # <Date or Ref ID>

Sample #2 Policy # <Date or Ref ID>

Sample #3 Policy # <Date or Ref ID>

Sample #4 Policy # <Date or Ref ID>

Sample #5 Policy # <Date or Ref ID>

Sample #6 Policy # <Date or Ref ID>

Sample #7 Policy # <Date or Ref ID>

Sample #8 Policy # <Date or Ref ID>

Sample #9 Policy # <Date or Ref ID>

Sample #10 Policy # <Date or Ref ID>

# Errors Identified

Overall Results (Pass - <95% // Attention Needed 93-94% // Fail >93%)

New Policies - General

1

Is the application the approved MetLife application?

Legal/Regulatory

6

NA

Fail

NA

Pass

Fail

NA

Pass

Fail

NA

Fail

NA

4

2

Is the application complete with all the required information, including the beneficiary (as applicable)?

Transaction

6

NA

Fail

NA

Pass

Fail

NA

Pass

Fail

NA

Pass

NA

3

3

Has the application been logged into the internal system of record to track time to process?

Legal/Regulatory OR Transaction

8

Pass

Fail

Fail

Pass

Fail

NA

Pass

Fail

NA

NA

Pass

4

4

Has a review been completed to ensure that the information provided by the applicant appears appropriate and meets all applicable local requirements (e.g. AML, FATCA, CRS)?

Legal/Regulatory

9

Fail

Fail

NA

Pass

Fail

NA

Pass

Fail

Fail

Fail

Fail

7

<tbody>
</tbody>

For sample size Area - Only Pass & Fail make up the sample size and the challenge is with Overall results only.

 

[Michael M]

Is this what you're after ??
But with such small sample sizes, I'm guessing it will always be a fail !!!

=IF(P5/D5<0.93,"Fail",IF(P5/D5<=0.94,"Attenion Needed","Pass"))

 

[ANAND KUMAR]

Sorry for delay in response!

Yes. That's what I needed.....Thanks ☺.