

Now, it’s time to create a drop down list in the form.
#Ms excel drop down list how to
Related Content: How to Create List from Range in Excel (3 Methods) As we are creating a form for compound interest, we need this information from a user: Here, we have to provide these fields with their names.In a similar way, create the following fields:.Now, merge Cell E5 and It will be our input field.First, merge Cell C5 and D5 to make it a single cell.Now, it’s time to create the form elements. Related Content: Create Excel Filter Using Drop-Down List Based on Cell Value It will surely enrich your Excel knowledge.įirst, of all select an area on your Worksheet where you will create your custom form.Īfter that, select your background color. In the following sections, we will create a form in the Excel worksheet with drop down list. Step by Step to Create a Form with Drop Down List in Excel Rather than, it will be counted on your current balance of $1030. That’s pretty simple.īut, in the second year, the interest won’t be counted on that $1000. And the bank provides a compound interest of 3% every year.Īfter one year, your balance will be $1030. Suppose, you deposited $1000 to a bank for 2 years. But, with compound interest, after a separately compound term, the interest accumulated over that span is added to the principal so that the following estimation of interest incorporates the actual principal plus the previously acquired interest. And also interest is not added to the principal. In Simple Interest, interest is only estimated from the principal. It increases our savings after a limited period.

:max_bytes(150000):strip_icc()/001-create-drop-down-list-in-excel-4570895-265b15756c9942898a644fe145ba1972.jpg)
When we think about compound interest, we consider it as gaining money. Basically, it is one of those popular financial terms. Read the following section to know about it more.Ĭompound interest means earning or paying interest on interest. It will take some value from you and give you the final result.īefore we start, you need to have some basic idea about compound interest. Here, we are going to create a form of Compound Interest.
