$$Excel-Macros$$ Problem with file copy using vba

2011-05-18 Thread Anuj Sharma 
Hey all,
I am copying data from shared folder to my hard drive using file copy
function.
Everything works fine if user is on office network . But if user is on
public network , he connects through Vpn. Problem comes  when Vpn get
disconnected on between . Excel cannot find shared folder and throws an
error.
I am looking for any solution that make excel wait till connection is
available again. Or there is another way to transfer file bit by bit.
Thanks in advance.
Anuj

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ database concept - Reg

2011-05-18 Thread saggi 
Create a custom list by typing in values

Click the Microsoft Office Button , and then click Excel Options.
Click the Popular category, and then under Top options for working
with Excel, click Edit Custom Lists.
In the Custom Lists box, click NEW LIST, and then type the entries in
the List entries box, beginning with the first entry.
Press ENTER after each entry.

When the list is complete, click Add.
The items in the list that you selected are added to the Custom lists
box.

Click OK twice.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to remove space in excel cell

2011-05-18 Thread anandydr 
At times the space is leading space which is not completely removed
using TRIM ( ) could anyone suggest what to do in such case?

On May 18, 3:38 am, "STDEV(i)"  wrote:
> sometimes what we thought as the space (as prefix or suffix) turns out to be
>  *Char (160)*so we need formula like this
> =SUBSTITUTE(A1,CHAR(160),"")
>
> On Sun, May 15, 2011 at 12:48 PM, Prabhu  wrote:
> > Hi friends,
> > How to remove spaces(bugs) in a particular cell either will be as
> > prefix or suffix before or after  number or text.
> > Regards,
> > Prabhu

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Help with Budget - Formula

2011-05-18 Thread Ashish Pradhan 


Hello Guys

Any help?


Thanks


Ashish Pradhan

On 5/15/2011 10:52 PM, Ashish Pradhan wrote:

Hello All

Please see attached an excel file.

I need a formula to automatically reduce the closing balance from the 
proper "Funds" wherever there are instances of the "funds" being 
utilised.


The attached excel file will give more clarity. Please let me know if 
you need any more clarity.



Thanks in advance.


Ashish



--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


sample.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Help on Transpose Function based upon criteria

2011-05-18 Thread KAUSHIK SAVLA 
Hi All,

I want to transpose certain data from row to column if meets specific
criteria: eg
Whole data is as below:
Claim No.   Amount
1   10
2   20
1   30
1   10
2   20


I want as

Claim No.
1  10  30  10

I want transpose to happen if meets criteria that it match the claim number,
i have 5 records as such.

I have attached an spreadsheet as example

Please help its urgent.

Regards,
Kaushik

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Transpose Help reqd.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help on Transpose Function based upon criteria

2011-05-18 Thread NOORAIN ANSARI 
Dear Kaushik,

see if it help

On Wed, May 18, 2011 at 4:06 PM, KAUSHIK SAVLA wrote:

> Hi All,
>
> I want to transpose certain data from row to column if meets specific
> criteria: eg
> Whole data is as below:
> Claim No.   Amount
> 1   10
> 2   20
> 1   30
> 1   10
> 2   20
>
>
> I want as
>
> Claim No.
> 1  10  30  10
>
> I want transpose to happen if meets criteria that it match the claim
> number, i have 5 records as such.
>
> I have attached an spreadsheet as example
>
> Please help its urgent.
>
> Regards,
> Kaushik
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Transpose_Help_reqd(solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ How to remove space in excel cell

2011-05-18 Thread STDEV(i) 
check whether the character is space  / CHAR(32)

=CODE(A1)
if this formula returns 32 then use TRIM
if this formual returns other numbers that 32 (space) use  SUBSTITUTE



On Wed, May 18, 2011 at 2:43 PM, anandydr  wrote:

> At times the space is leading space which is not completely removed
> using TRIM ( ) could anyone suggest what to do in such case?
>
> On May 18, 3:38 am, "STDEV(i)"  wrote:
> > sometimes what we thought as the space (as prefix or suffix) turns out to
> be
> >  *Char (160)*so we need formula like this
> > =SUBSTITUTE(A1,CHAR(160),"")
> >
> > On Sun, May 15, 2011 at 12:48 PM, Prabhu 
> wrote:
> > > Hi friends,
> > > How to remove spaces(bugs) in a particular cell either will be as
> > > prefix or suffix before or after  number or text.
> > > Regards,
> > > Prabhu
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: Help with Budget - Formula

2011-05-18 Thread ashish koul 
cell ( b3)  =B2-SUMIF(C6:C65356,B1,D6:D65356)
cell(c3)=C2-SUMIF(C6:C65356,C1,D6:D65356)
On Wed, May 18, 2011 at 2:00 PM, Ashish Pradhan wrote:

>
> Hello Guyscell
>
> Any help?
>
>
> Thanks
>
>
> Ashish Pradhan
>
> On 5/15/2011 10:52 PM, Ashish Pradhan wrote:
>
>> Hello All
>>
>> Please see attached an excel file.
>>
>> I need a formula to automatically reduce the closing balance from the
>> proper "Funds" wherever there are instances of the "funds" being utilised.
>>
>> The attached excel file will give more clarity. Please let me know if you
>> need any more clarity.
>>
>>
>> Thanks in advance.
>>
>>
>> Ashish
>>
>>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help on Transpose Function based upon criteria

2011-05-18 Thread Raghunandan 
hatts o..

On Wed, May 18, 2011 at 8:19 PM, NOORAIN ANSARI wrote:

> Dear Kaushik,
>
> see if it help
>
> On Wed, May 18, 2011 at 4:06 PM, KAUSHIK SAVLA wrote:
>
>> Hi All,
>>
>> I want to transpose certain data from row to column if meets specific
>> criteria: eg
>> Whole data is as below:
>> Claim No.   Amount
>> 1   10
>> 2   20
>> 1   30
>> 1   10
>> 2   20
>>
>>
>> I want as
>>
>> Claim No.
>> 1  10  30  10
>>
>> I want transpose to happen if meets criteria that it match the claim
>> number, i have 5 records as such.
>>
>> I have attached an spreadsheet as example
>>
>> Please help its urgent.
>>
>> Regards,
>> Kaushik
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help on Transpose Function based upon criteria

2011-05-18 Thread STDEV(i) 
*Array Formula, written in 9 cells (oneRow Range) at once !*

=IFERROR(TRANSPOSE(INDEX($B$3:$B$11,SMALL(IF($A$3:$A$11=$C16,ROW($1:$9)),ROW($1:$9,"")


On Wed, May 18, 2011 at 5:36 PM, KAUSHIK SAVLA wrote:

> Hi All,
>
> I want to transpose certain data from row to column if meets specific
> criteria: eg
> Whole data is as below:
> Claim No.   Amount
> 1   10
> 2   20
> 1   30
> 1   10
> 2   20
>
>
> I want as
>
> Claim No.
> 1  10  30  10
>
> I want transpose to happen if meets criteria that it match the claim
> number, i have 5 records as such.
> I have attached an spreadsheet as example
> Please help its urgent.
> Regards,
> Kaushik
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


ctv_Conditional_Transpose.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Macro for Converting txt to xls using Text Import Wizard

2011-05-18 Thread Susan 1 
Hi ~

Wondering if you could assist me with the Text import wizard to configure
the columns and tab delimiter for the attached txt file.  And then send me
the steps.



I will be needing to do this every week to the same types of txt files,
importing into Excel and I’d like to create a Macro for this but cannot
figure out how to set the tab/columns.


Thanks,

Sunnie

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Date|Time|From|To|MessageContents
04/25/2011|06:54:00Robert 
L|2065409868|CCU-YELLOW(1).IMC-red(0).TELE-red(0).MS-GREEN(7).CURRENT 
CENSUS:210# OF ED PTS:8ED BOARDERS:4 tele 1 IMC.LAST DIVERT:2/16/2011There are 
26 am and 60 total surgeries today.|
04/25/2011|09:32:39elaine|2065409868|Location: Bed ControlNeeds: Please come to 
1000 bed huddle, thanks.|
04/25/2011|11:10:42Elaine|2065409868|CCU- 1IMC- 0TELE-0 MS- 2 all areas 
redCURRENT CENSUS:213# OF ED PTS:22ED BOARDERS:3 2 tele 1 imcLAST DIVERT:2/16|
04/25/2011|03:58:40|2065409868|CCU- 1 redIMC- 0 redTELE- 3 yellowMS- 4 
redCURRENT CENSUS:209# OF ED PTS:23ED BOARDERS:0LAST DIVERT:2/16|
04/25/2011|07:13:50|2065409868|CCU- 1 REDIMC-1 RED TELE- 4YELLOWMS- 10 
GREENCURRENT CENSUS:211# OF ED PTS:21ED BOARDERS:0LAST DIVERT:2/16|
04/26/2011|12:28:52BILLIE|2065409868|CCU-1 IMC-1 TELE-1 MS- 6CURRENT 
CENSUS:227# OF ED PTS:5ED BOARDERS:0LAST DIVERT:02/16|
04/26/2011|06:57:19Billie|2065409868|CCU- 1IMC- 0TELE- 0MS- 7CURRENT 
CENSUS:229AM SURG:37IP SURG:4OP SURG:32TOTAL SURG: 73# OF ED PTS:3ED 
BOARDERS:1LAST DIVERT:02/16|
04/26/2011|09:48:31X10313|2065409868|Location: Bed ControlNeeds: Please come to 
1000 bed huddle, thanks.|
04/26/2011|11:45:35x10313|2065409868|CCU- 2IMC- 0TELE-0MS- 6CURRENT CENSUS: 
223# OF ED PTS:9ED BOARDERS:0LAST DIVERT:2/16|
04/26/2011|03:56:55x10313|2065409868|CCU-2 IMC-0 TELE-0 MS-2 CURRENT 
CENSUS:218# OF ED PTS:10ED BOARDERS:0LAST DIVERT:2/16ED with 4 pts awaiting 
beds|
04/26/2011|04:12:47x10313|2065409868|Correction to Flow Alert:ED has 3 pts 
bording and 1 awaiting a bed, instead of 0 borders and 4 awaiting beds.|
04/26/2011|07:11:30x10313|2065409868|CCU-0IMC-0TELE-0MS-0CURRENT CENSUS:228# OF 
ED PTS:11ED BOARDERS:2LAST DIVERT:2/16|
04/27/2011|12:36:45Robert 
L|2065409868|CCU-red(0).IMC-red(0).TELE-red(0).MS-yellow(4).CURRENT CENSUS:241# 
OF ED PTS:17ED BOARDERS:2 (IMC)LAST DIVERT:2/16/2011|
04/27/2011|07:11:20Robert L|2065409868|CCU-Red(0).IMC- 
Red(0).TELE-Red(0).MS-Red(4).CURRENT CENSUS:247.AM SURG:28IP SURG:4OP 
SURG:36TOTAL SURG:68# OF ED PTS:3ED BOARDERS:1 imc 1 rcmLAST DIVERT:2/16/2011|
04/27/2011|09:37:5910313|2065409868|Location: Bed ControlNeeds: Please come to 
1000 bed huddle, thanks.|
04/27/2011|11:01:53|2065409868|CCU- 0 REDIMC- 0 REDTELE-0 RED MS- 2 REDCURRENT 
CENSUS:242# OF ED PTS:15ED BOARDERS:4 (1 TELE, 1 IMC, 1 RCM, 1 MS)LAST 
DIVERT:2/16|
04/27/2011|06:47:48ELAINE|2065409868|CCU- 1+O/C YELLOWIMC- 1 REDTELE- 2 REDMS- 
0 REDCURRENT CENSUS:230# OF ED PTS:18ED BOARDERS:9 5 MS, 3 BEDS PENDING, 2 IMC 
BEDS PENDING,2 RCM BEDS PENDINGLAST DIVERT:2/16|
04/28/2011|06:28:01Billie|2065409868|CCU-0 IMC- 0TELE- 1MS- 4CURRENT 
CENSUS:251AM SURG:35IP SURG:4OP SURG:33TOTAL SURG:72# OF ED PTS:2ED 
BOARDERS:1LAST DIVERT:02/16|
04/28/2011|07:34:37|2065409868|IV TEAM IS RUNNING SHORT 1 RN TODAY.  PLEASE BE 
PATIENT WITH THEM. THANKS  |
04/28/2011|09:49:41Robert L|2065409868|Location: Bed ControlNeeds: Please come 
to 1000 bed huddle, thanks.|
04/28/2011|11:37:43Robert L|2065409868|CCU-red(0).IMC-red(0).TELE-red(0). 
MS-red(0). CURRENT CENSUS:246# OF ED PTS:12ED BOARDERS: 2 msLAST 
DIVERT:2/16/2011|
04/28/2011|03:20:43Robert 
L|2065409868|CCU-red(0).IMC-red(0).TELE-red(0).MS-red(1). CURRENT CENSUS:235# 
OF ED PTS:22ED BOARDERS: 1 imcLAST DIVERT:2/16/2011|
04/28/2011|06:42:39Robert 
L|2065409868|CCU-Green(2).IMC-red(0).TELE-red(1).MS-red(0).CURRENT CENSUS:255# 
OF ED PTS:16ED BOARDERS:2 msLAST DIVERT:2/16/2011|
04/29/2011|07:02:5810313|2065409868|CCU- 1IMC- 0TELE-1 MS- 6CURRENT 
CENSUS:262AM SURG:275IP SURG:1OP SURG:35TOTAL SURG:63# OF ED PTS:2ED BOARDERS:1 
RCMLAST DIVERT:2/16|
04/29/2011|09:52:4810313|2065409868|Location: Bed ControlNeeds: Please come to 
1000 bed huddle, thanks.|
04/29/2011|12:09:2310313|2065409868|CCU- RED 1IMC- RED 0TELE- RED 0MS- RED 
2CURRENT CENSUS:250# OF ED PTS:18ED BOARDERS: 1 TELELAST DIVERT:2/16|
04/29/2011|04:05:2910313|2065409868|CCU- RED 1IMC- RED 2TELE- RED 1 MS- RED 
4CURRENT CENSUS:234#

$$Excel-Macros$$ Problem with Nested IF formula

2011-05-18 Thread P.VIJAYKUMAR 
Dear Ashish,


In our company we give cash discounts for the dealers who pay cash within
the stipulated time  period. The conditions are as in the following table

   CD  POLICY  FOR THE MONTH OF OCTOBER




 SlNo. CD PolicyCategory  > 2 Lakhs > 1 Lakh < 1 Lakh  1 Advance 10% 9%
8%  2 < 30 Days 8% 7% 6%  3 < 60 Days 6% 5% 4%  4 < 90 Days 4% 3% 2%
The table may be explained as follows.

If the person pays money in advance without doing billing he gets he gets
the discount as per the rates given in the advance row.If he make sales
(billing)  and pays amount within 30 to 90days he gets the discounts
according to the slabs prescribed for 30,60, 90 days respectively as shown
above. I am trying to write nested IF formula for the payments received but
I am unable to do so satisfying all conditions.

I request all the members and also all you personally  to write a
formula(Nested IF or any other formula) satisfying all the conditions which
would be of a great help in my job.




Thanks & Regards,
P.VIJAY KUMAR

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel