| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| If statement or lookup statement not sure | Excel Worksheet Functions | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Hybrid Mode
