What if three Consecutive year have negative % then what output you want..?

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nikhil Shah
Sent: Dec/Wed/2011 10:14
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help

 

Dear Friend,

 

I want to find out Consecutive Negative Return (%) in Times & Number Years :

 

Answer is : 2 Times & 2 Years....

 

Now i want EXCEL Formula..I am using EXCEL 2003 ..No VBA Code...Pl help me
..

 


Year

Return

Year

Return


1980

28.86%

1996

4.24%


1981

49.56%

1997

13.31%


1982

3.56%

1998

-17.17%


1983

7.20%

1999

63.57%


1984

8.15%

2000

-20.99%


1985

100.95%

2001

-17.92%


1986

-1.34%

2002

4.44%


1987

-18.43%

2003

74.49%


1988

49.60%

2004

11.62%


1989

18.85%

2005

42.33%


1990

27.56%

2006

48.35%


1991

95.88%

2007

45.61%


1992

33.62%

2008

-51.22%


1993

27.94%

2009

76.35%


1994

17.51%

2010

17.43%


1995

-20.45%

2011 till 7th Dec.

-17.71%

 

Regards

 

-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

Reply via email to