Help with IF Function

ANAND KUMAR

New Member
Joined
Oct 20, 2016
Messages
41
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


1





1


For ease attaching file herewith,

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


Any help would be appreciated.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,701
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
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

New Member
Joined
Oct 20, 2016
Messages
41
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

Well-known Member
Joined
Oct 27, 2005
Messages
19,701
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Is this what you're after ??
But with such small sample sizes, I'm guessing it will always be a fail !!!
Code:
=IF(P5/D5<0.93,"Fail",IF(P5/D5<=0.94,"Attenion Needed","Pass"))
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,418
Messages
5,596,028
Members
414,039
Latest member
southike

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top