The Excel file pertaining to this problem can be downloaded from here Max Scoring Subject Challenge 12 was a related challenge. Now, this time, you will need to find the maximum number which has been scored and by which student in which subject. This, you need to do without using a helper column. In case…
Tips & Tricks 91 – Financial Function – Calculate Compounded Interest
As part of our Mathematics courses in our childhood, we had learned about Compounded Interest. The famous formula which we remember is Compounded Balance = Principal x (1+rate)^N
Excel Quiz 12
Article 14 – Dependent Data List 00 – Create Dependent Data List
— The Excel files related to this article can be downloaded from Dependent Drop Down List_Single Words & Dependent Drop Down List_Multiple Words — Creation of dependent data list is a topic which I wanted to write and I have got some time to talk about this. In this article, I will be covering the dependency…
Challenge 13 – Generating Digit Product Sequences
Digit Product Sequences can be read here https://facstaff.bloomu.edu/ploomis/sequences.html In Summary, given a starting positive integer number, every succeeding number is previous number + product of non zeros digits of previous number. Hence, if starting number is 1, then Digit Product Sequences will be – 1, 2, 4, 8, 16, 22, 26, 38, 62, 74, 102,…
Tips & Tricks 90 – Financial Function – Calculate Interest Rate
You want to take a loan. You know how much loan to take (pmt), you know how many months you want to pay up (nper) and you want to know effective rate of interest. Excel makes it easy to do. RATE function is the answer for this.
Excel Quiz 11
Tips & Tricks 89 – Financial Function – Calculate Number of EMIs to Pay Up a Loan
You have taken a loan and you know your EMI capability. So, you want to know how many months will be taken to pay off a loan completely. It is fairly easy job to do it in Excel. You will need to use NPER function for this.
Tips & Tricks 88 – Financial Function – Calculate Principal Part of an EMI
This Tips and Tricks is in continuation of Tips & Tricks 84 – Financial Function – Calculate EMI. Now the EMI for a month = Interest for that month and Principal for that month. IPMT is used to calculate the interest portion of your EMI. This I talked about in Tips & Tricks 87 –…
Challenge 12 – Student Scoring Maximum Total Score
Download the file related to this problem from here Max Total Score Given the below grid, I need a formula in N2 and N3 which gives the name of the person scoring the total highest marks adding all subjects together. This, you need to do without a helper column. For example, in the below grid,…