offset formula

  • Thread starter Thread starter vmohan1978
  • Start date Start date
V

vmohan1978

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)-1>B$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
 
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.
 
Back
Top