IN CELL
B1 MY INPUT VALUE VARIES FROM 1-30
IN E1 MY INPUT WILL BE AMOUNT IT VARIES ASSUME 300000.
i WANT FORMULA IN A5 TO SHOW 0 AND A6 AS 1 SO ON TILL I GET THE INPUT IN B1
.. AND IN C5 I NEED A FORMULA =$E$1*((2*(A5/$B$1)^2-(A5/$B$1)^4) TILL SAME AS
IN COLUMN BASED ON THE VALUE IN B1.
WISH YOU ALL A VAERY HAPPY NEW YEAR -2010 IN ADVANCE



A B C D E F
G
1


2

3

Darn, I had to use PROPER to read your all caps posting (aw)
DO make it easy for all readers, don't use all CAPS in your postings. Ever.

Q1
In A5: =IF(ROWS($1:1)-1B$1,"",ROWS($1:1)-1)
Copy down to A35. A5:A35 will return the auto-serializing that I think you
seek, starting from zero till the max value that is specified for B1 (30).
The serializing terminates at the number that you input into B1.

Q2
In C5: =IF(A5="","",$E$1*((2*(A5/$B$1)^2-(A5/$B$1)^4)))
Copy down to C35. I merely bolted-on a front IF trap: =IF(A5="","", ...
to your formula as posted so that it returns correspondingly to the serial
numbers in A5:A35. Where the serial terminates, it returns blanks: "". I'm
guessing this is what you want to happen.

Above of any worth? Hit the YES below
--
Max
Singapore
---
"vmohan1978" wrote:
In Cell B1 My Input Value Varies From 1-30
In E1 My Input Will Be Amount It Varies Assume 300000

Q1
I Want Formula In A5 To Show 0 And A6 As 1 So On Till I Get The Input In B1

Q2
In C5 I Need A Formula =$E$1*((2*(A5/$B$1)^2-(A5/$B$1)^4) Till Same As
In Column Based On The Value In B1

Dear Max ,
Thanks for your suggestion regardin not to use caps in posting , i wll not
use all caps in my future posting.
It working perfectly thanks for you help. If i use chart ( Lines) what range
i have to select so that it changes automatically wrt to the no of months
without showing drop in the chart.


"Max" wrote:

Darn, I had to use PROPER to read your all caps posting (aw)
DO make it easy for all readers, don't use all CAPS in your postings. Ever.

Q1
In A5: =IF(ROWS($1:1)-1B$1,"",ROWS($1:1)-1)
Copy down to A35. A5:A35 will return the auto-serializing that I think you
seek, starting from zero till the max value that is specified for B1 (30).
The serializing terminates at the number that you input into B1.

Q2
In C5: =IF(A5="","",$E$1*((2*(A5/$B$1)^2-(A5/$B$1)^4)))
Copy down to C35. I merely bolted-on a front IF trap: =IF(A5="","", ...
to your formula as posted so that it returns correspondingly to the serial
numbers in A5:A35. Where the serial terminates, it returns blanks: "". I'm
guessing this is what you want to happen.

Above of any worth? Hit the YES below
--
Max
Singapore
---
"vmohan1978" wrote:
In Cell B1 My Input Value Varies From 1-30
In E1 My Input Will Be Amount It Varies Assume 300000

Q1
I Want Formula In A5 To Show 0 And A6 As 1 So On Till I Get The Input In B1

Q2
In C5 I Need A Formula =$E$1*((2*(A5/$B$1)^2-(A5/$B$1)^4) Till Same As
In Column Based On The Value In B1

For your new query, try a fresh posting in microsoft.public.excel.charting
--
Max
Singapore
----
"vmohan1978" wrote in message
...
Dear Max ,
Thanks for your suggestion regardin not to use caps in posting , i wll not
use all caps in my future posting.
It working perfectly thanks for you help. If i use chart ( Lines) what
range
i have to select so that it changes automatically wrt to the no of months
without showing drop in the chart.