• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Incremental year number based on cell value

B

Brandt

New Member
Hi all

Please help. Is this possible with a simple formula or vba. I am trying to make a interest calculator.

regards

Untitled.jpg
 
Hi ,

Do you want that the text Year 1 , Year 2 ,... should be filled up in cells based on what value is entered in another cell ?

If so , it is certainly possible using a formula.

=IF(ROW(A1) <= value in cell , "Year " & ROW(A1), "")

If your entered value of 6 , 10 ,... is in cell P1 , then the formula will become :

=IF(ROW(A1) <= $P$1, "Year " & ROW(A1), "")

Narayan
 
Hi Narayan

Thank you for the reply. Yes the text should display "Year 1", "Year 2", etc. and it does make sense but will it solve my problem in full? My question is the following: If I enter 5 into A1 then the lines should display "Year 1", "Year 2" ... "Year 5" and if I enter 7 in A1 display Year 1 to 7 and so on. I know, I know this is no ordinary question but, I am no ordinary excel user. Ha ha ha. I will upload the current sheet if you like and explain in the sheet.

Regards
 
Hi all,

Thanks for the feedback. I tried the formula and it worked perfectly. A few tweaks later and i have what i am looking for. Thank you very much. I dont ask a lot of questions but, on chandoo.org, I always find the help i am looking for!

Regards
 
You must log in or register to reply here.
Back
Top