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.
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.
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.
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.
This is a very good help for excel liking people.
Thank you Rajan!
One fundamental question. Are there any subscription charges?
Hi Nobin,
No, there are no subscription charges for the blog.