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