I hope you have seen the last video where i demonstrated how to do Addition Multiplication Division and Subtraction . These complex formulas uses all those simple operations. Assuming that you have seen that let’s go into creating these formula into the excel sheet.
How to create a complex Excel Formula
So the formulae I have chosen are for Simple Interest and Compound Interest you use this in calculating your finances especially if you have a loan or if you have put a deposit into the bank.
For ease I’m going to copy-paste this as an image into our excel sheet so for that I press Win-Shift-S button. And that allows me to catch a snap from the screen the chosen area. I go into our excel sheet and paste it resizing it to a fairly reasonable size.
This will be here on the right side for our reference and in the left side we will create the formula. You can see that both these formula have three variables principal number of years and rate of interest here.
