Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help me with some formula?
I have an Excel File with the range of A1:AR35. I need some formula in the
range AM6:AR35. The requirement is to get the results according to the credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and whichever payment is overdue in the columns with the heading as follows: Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days" "Overdue 90 - 120 days" "Overdue 120 days" It is a Client Position file, which I cannot describe through this. If anybody can help me I can send the file through email. Please, it is prestige issue. Jaleel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help me with some formula?
send the details
"Jaleel" wrote: I have an Excel File with the range of A1:AR35. I need some formula in the range AM6:AR35. The requirement is to get the results according to the credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and whichever payment is overdue in the columns with the heading as follows: Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days" "Overdue 90 - 120 days" "Overdue 120 days" It is a Client Position file, which I cannot describe through this. If anybody can help me I can send the file through email. Please, it is prestige issue. Jaleel |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help me with some formula?
Can you please send me your email id?
"ciwa" wrote: send the details "Jaleel" wrote: I have an Excel File with the range of A1:AR35. I need some formula in the range AM6:AR35. The requirement is to get the results according to the credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and whichever payment is overdue in the columns with the heading as follows: Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days" "Overdue 90 - 120 days" "Overdue 120 days" It is a Client Position file, which I cannot describe through this. If anybody can help me I can send the file through email. Please, it is prestige issue. Jaleel |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help me with some formula?
A footnote:
I am expecting a response from Dave / Gord / Rag / Biff / Max / Garys / Bob / ???? With humble regards, Jaleel "Jaleel" wrote: I have an Excel File with the range of A1:AR35. I need some formula in the range AM6:AR35. The requirement is to get the results according to the credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and whichever payment is overdue in the columns with the heading as follows: Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days" "Overdue 90 - 120 days" "Overdue 120 days" It is a Client Position file, which I cannot describe through this. If anybody can help me I can send the file through email. Please, it is prestige issue. Jaleel |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help me with some formula?
Do you have a column with the number of days overdue?
Are you just after an IF statement? If you could just describe the key column headers i might be able to help. "Jaleel" wrote: A footnote: I am expecting a response from Dave / Gord / Rag / Biff / Max / Garys / Bob / ???? With humble regards, Jaleel "Jaleel" wrote: I have an Excel File with the range of A1:AR35. I need some formula in the range AM6:AR35. The requirement is to get the results according to the credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and whichever payment is overdue in the columns with the heading as follows: Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days" "Overdue 90 - 120 days" "Overdue 120 days" It is a Client Position file, which I cannot describe through this. If anybody can help me I can send the file through email. Please, it is prestige issue. Jaleel |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help me with some formula?
You don't give enough info but try looking the help index for COUNTIF and SUMIF -- Don Guillett SalesAid Software "Jaleel" wrote in message ... I have an Excel File with the range of A1:AR35. I need some formula in the range AM6:AR35. The requirement is to get the results according to the credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and whichever payment is overdue in the columns with the heading as follows: Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days" "Overdue 90 - 120 days" "Overdue 120 days" It is a Client Position file, which I cannot describe through this. If anybody can help me I can send the file through email. Please, it is prestige issue. Jaleel |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help me with some formula?
Cin,
I have columns with the number of days overdue. There I want to get the results of each client after calculating the credit days. Many if statements will be required to achieve it. If one client has 30 days credit terms and only the current month is pending it should appear under the column heading "Not due". If he has two months overdue, the previous month's overdue should appear under the column heading "Overdue 30 days". But remember it is meant for the whole financial year i.e., up to Aug-07. That is the only difficulty I face to put the formula. I need someone to receive my file and to put a proper formula as my Company desires. Last month somehow I achieved it with some if formula. But this month the whole formula gone absurd as the formula is not touching the cell reference of Dec-06. It should change as the month progresses up to Aug-07. Can anyone with some brilliance and willingness to help me write to me with his/her email id? Awaiting, Jaleel "Cin" wrote: Do you have a column with the number of days overdue? Are you just after an IF statement? If you could just describe the key column headers i might be able to help. "Jaleel" wrote: A footnote: I am expecting a response from Dave / Gord / Rag / Biff / Max / Garys / Bob / ???? With humble regards, Jaleel "Jaleel" wrote: I have an Excel File with the range of A1:AR35. I need some formula in the range AM6:AR35. The requirement is to get the results according to the credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and whichever payment is overdue in the columns with the heading as follows: Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days" "Overdue 90 - 120 days" "Overdue 120 days" It is a Client Position file, which I cannot describe through this. If anybody can help me I can send the file through email. Please, it is prestige issue. Jaleel |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help me with some formula?
Don,
I have sent the file to you. Try your level best to find a solution, even the giants are keeping silent. Sincere Regards, Jaleel "Don Guillett" wrote: You don't give enough info but try looking the help index for COUNTIF and SUMIF -- Don Guillett SalesAid Software "Jaleel" wrote in message ... I have an Excel File with the range of A1:AR35. I need some formula in the range AM6:AR35. The requirement is to get the results according to the credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and whichever payment is overdue in the columns with the heading as follows: Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days" "Overdue 90 - 120 days" "Overdue 120 days" It is a Client Position file, which I cannot describe through this. If anybody can help me I can send the file through email. Please, it is prestige issue. Jaleel |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help me with some formula?
Is this what you are after?
=IF(AM6=0, "Not Due", IF(AM6<30, "Overdue < 30 days", IF(AM6<60, "Overdue 30-60 days", IF(AM6<90, "Overdue 60-90 days", IF(AM6<121, "Overdue 90-100 days", IF(AM6120, "Overdue 120 days","")))))) "Jaleel" wrote: Don, I have sent the file to you. Try your level best to find a solution, even the giants are keeping silent. Sincere Regards, Jaleel "Don Guillett" wrote: You don't give enough info but try looking the help index for COUNTIF and SUMIF -- Don Guillett SalesAid Software "Jaleel" wrote in message ... I have an Excel File with the range of A1:AR35. I need some formula in the range AM6:AR35. The requirement is to get the results according to the credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and whichever payment is overdue in the columns with the heading as follows: Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days" "Overdue 90 - 120 days" "Overdue 120 days" It is a Client Position file, which I cannot describe through this. If anybody can help me I can send the file through email. Please, it is prestige issue. Jaleel |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help me with some formula?
Cin,
Thank you for your efforts. I am not after the formula you sent. The overdue amount should appear under these specific headings, picking from the monthly invoice amounts starting from column E to AI. I know it is not a simple job, otherwise I could have figured it out. I need someone without a professional approach to help me. I appreciate your sincerity to spend some time for me. Regards, Jaleel "Cin" wrote: Is this what you are after? =IF(AM6=0, "Not Due", IF(AM6<30, "Overdue < 30 days", IF(AM6<60, "Overdue 30-60 days", IF(AM6<90, "Overdue 60-90 days", IF(AM6<121, "Overdue 90-100 days", IF(AM6120, "Overdue 120 days","")))))) "Jaleel" wrote: Don, I have sent the file to you. Try your level best to find a solution, even the giants are keeping silent. Sincere Regards, Jaleel "Don Guillett" wrote: You don't give enough info but try looking the help index for COUNTIF and SUMIF -- Don Guillett SalesAid Software "Jaleel" wrote in message ... I have an Excel File with the range of A1:AR35. I need some formula in the range AM6:AR35. The requirement is to get the results according to the credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and whichever payment is overdue in the columns with the heading as follows: Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days" "Overdue 90 - 120 days" "Overdue 120 days" It is a Client Position file, which I cannot describe through this. If anybody can help me I can send the file through email. Please, it is prestige issue. Jaleel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |