Contact

Rushabh@DLTC.co

+91-98190 60617

6 Comments

  1. Chris

    I was fascinated by your video Fixed Deposits Tracker – Across Banks Across Accounts on youtube. One thing that had me confused was how did you get the number in the “No of Days To” to change when you also changed the figurein the Maturing in the next “x” days box. In the Maturing box you type a number and the box which says <=? also changes. How is this done.

    Reply

    • rushabhs

      Hi Chris,

      Sorry for the late reply. I’m glad the video has interested you.

      For the “No. of days to” box, i have used the & function.
      =”< ="&O3 & basically combines contents of 2 or more cells (or a manual mentioned content like <= with cell content of O3) into 1 single cell. What it does is, it will give you <= the value in cell O3. O3 is the Maturing in next 'x' days. So when you lets say put 30 in cell O3, the "No. of days to" becomes "<=30" Inline image 1 Instead of &, you can also use =CONCATENATE ( "<=",O3) The result will be the same. Visit this link to understand the =CONCATENATE function in-depth http://www.excelrush.com/concatenate-to-combine-content-of-multiple-cells/

      Feel free to write to me anytime for any more doubts if you have.

      Reply

  2. Rajan Naidu

    This is a very good help for excel liking people.

    Reply

    • rushabhs

      Thank you Rajan!

      Reply

  3. Nobin Pradhan

    One fundamental question. Are there any subscription charges?

    Reply

    • rushabhs

      Hi Nobin,

      No, there are no subscription charges for the blog.

      Reply

Leave a Reply

*