IF statement

[Guest]

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

 

[Executor]

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(C2>5, C2<11), D2, 0)
For column G: =IF(AND(C2>10, C2<16), D2, 0)
For column H: =IF(AND(C2>15, D2, 0)

Hoop that helps

Executor

 

[Ron Rosenfeld]

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((ElapsTim>5)*(ElapsTim<=10)*NumClaims)
11-15: =SUMPRODUCT((ElapsTim>10)*(ElapsTim<=15)*NumClaims)

15: =SUMPRODUCT((ElapsTim>15)*NumClaims)

ElapsTime: C2:Cn
NumClaims D2n


--ron

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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]

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

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