IF statement
 

Hi Experts, I need urgent help Please!!!
I have data of Batches of claims
Column A is date received, Column B is date processed, Column C is time
taken to process (diferrence of Column A and Column B), Column D has number
of claims in the batch, now I need to add and display number of claims that
were processed in 1 - 5 days 6 -10 days 11 - 15 days and 15+ days. is it
possible using If statement???Is it possible in Excel without using macros???
Please Please help me!!!

IF statement
 

Hi Mir Khan

I guess you want those figures in separate columns. Let us say Column E
up to H.
For column E: =IF(C2<6, D2, 0)
For column F: =IF(AND(C25, C2<11), D2, 0)
For column G: =IF(AND(C210, C2<16), D2, 0)
For column H: =IF(AND(C215, D2, 0)

Hoop that helps

Executor

IF statement
 

On Tue, 15 Nov 2005 12:31:04 -0800, "Mir Khan"
wrote:

Hi Experts, I need urgent help Please!!!
I have data of Batches of claims
Column A is date received, Column B is date processed, Column C is time
taken to process (diferrence of Column A and Column B), Column D has number
of claims in the batch, now I need to add and display number of claims that
were processed in 1 - 5 days 6 -10 days 11 - 15 days and 15+ days. is it
possible using If statement???Is it possible in Excel without using macros???
Please Please help me!!!

Assuming named ranges that do not include an entire column:

1-5: =SUMPRODUCT((ElapsTim<=5)*NumClaims)
6-10: =SUMPRODUCT((ElapsTim5)*(ElapsTim<=10)*NumClaims)
11-15: =SUMPRODUCT((ElapsTim10)*(ElapsTim<=15)*NumClaims )
15: =SUMPRODUCT((ElapsTim15)*NumClaims)

ElapsTime: C2:Cn
NumClaims D2:Dn


--ron

IF statement
 

Thanx for the help i hope this will work too, i appreciate it

"Ron Rosenfeld" wrote:

On Tue, 15 Nov 2005 12:31:04 -0800, "Mir Khan"
wrote:

Hi Experts, I need urgent help Please!!!
I have data of Batches of claims
Column A is date received, Column B is date processed, Column C is time
taken to process (diferrence of Column A and Column B), Column D has number
of claims in the batch, now I need to add and display number of claims that
were processed in 1 - 5 days 6 -10 days 11 - 15 days and 15+ days. is it
possible using If statement???Is it possible in Excel without using macros???
Please Please help me!!!

Assuming named ranges that do not include an entire column:

1-5: =SUMPRODUCT((ElapsTim<=5)*NumClaims)
6-10: =SUMPRODUCT((ElapsTim5)*(ElapsTim<=10)*NumClaims)
11-15: =SUMPRODUCT((ElapsTim10)*(ElapsTim<=15)*NumClaims )
15: =SUMPRODUCT((ElapsTim15)*NumClaims)

ElapsTime: C2:Cn
NumClaims D2:Dn


--ron

IF statement
 

Thanx for the help i hope this will work, i appreciate it

"Executor" wrote:

Hi Mir Khan

I guess you want those figures in separate columns. Let us say Column E
up to H.
For column E: =IF(C2<6, D2, 0)
For column F: =IF(AND(C25, C2<11), D2, 0)
For column G: =IF(AND(C210, C2<16), D2, 0)
For column H: =IF(AND(C215, D2, 0)

Hoop that helps

Executor

IF statement
 

Hey I got it Thank you I appreciate your help, it was so very necessary for
me...you made my day...i am leaving home satisfied.
Thanks again

"Ron Rosenfeld" wrote:

On Tue, 15 Nov 2005 12:31:04 -0800, "Mir Khan"
wrote:

Hi Experts, I need urgent help Please!!!
I have data of Batches of claims
Column A is date received, Column B is date processed, Column C is time
taken to process (diferrence of Column A and Column B), Column D has number
of claims in the batch, now I need to add and display number of claims that
were processed in 1 - 5 days 6 -10 days 11 - 15 days and 15+ days. is it
possible using If statement???Is it possible in Excel without using macros???
Please Please help me!!!

Assuming named ranges that do not include an entire column:

1-5: =SUMPRODUCT((ElapsTim<=5)*NumClaims)
6-10: =SUMPRODUCT((ElapsTim5)*(ElapsTim<=10)*NumClaims)
11-15: =SUMPRODUCT((ElapsTim10)*(ElapsTim<=15)*NumClaims )
15: =SUMPRODUCT((ElapsTim15)*NumClaims)

ElapsTime: C2:Cn
NumClaims D2:Dn


--ron

IF statement
 

You're welcome. Glad to help. Thanks for the feedback.



On Tue, 15 Nov 2005 15:09:04 -0800, "Mir Khan"
wrote:

Hey I got it Thank you I appreciate your help, it was so very necessary for
me...you made my day...i am leaving home satisfied.
Thanks again

"Ron Rosenfeld" wrote:

On Tue, 15 Nov 2005 12:31:04 -0800, "Mir Khan"
wrote:

Hi Experts, I need urgent help Please!!!
I have data of Batches of claims
Column A is date received, Column B is date processed, Column C is time
taken to process (diferrence of Column A and Column B), Column D has number
of claims in the batch, now I need to add and display number of claims that
were processed in 1 - 5 days 6 -10 days 11 - 15 days and 15+ days. is it
possible using If statement???Is it possible in Excel without using macros???
Please Please help me!!!

Assuming named ranges that do not include an entire column:

1-5: =SUMPRODUCT((ElapsTim<=5)*NumClaims)
6-10: =SUMPRODUCT((ElapsTim5)*(ElapsTim<=10)*NumClaims)
11-15: =SUMPRODUCT((ElapsTim10)*(ElapsTim<=15)*NumClaims )
15: =SUMPRODUCT((ElapsTim15)*NumClaims)

ElapsTime: C2:Cn
NumClaims D2:Dn


--ron


--ron