Total number of doses x mg per dose = total mg for compounding mixture.
1. Plug in the numbers you are using into the formula. 1  For example, if you want to invest $5,000 with an interest rate of 3.45%, compounded monthly for 2 years, you would write FV=5,000(1+.0345/12)^(12x2). 2  Turn your interest rate into a decimal before plugging it into the formula. 3  Divide by 100 to get the decimal Supply the above numbers into the compound interest formula, and you will get the following result: =$2,000 * (1 + 0.000219178)1825 = $2,983.52. As you see, with daily compounding interest, the future value of the same investment is a bit higher than with monthly compounding. In our example, the formula is =A2*(1+$B2) where A2 is your initial deposit and B2 is the annual interest rate. Please pay attention that we fix the reference to column B by using the $ sign. As you remember, 1% is one part of a hundred, i.e. 0.01, so 7% is 0.07, and this is how percentages are actually stored in Excel. The tutorial explains the compound interest formula for Excel and provides examples of how to calculate the future value of the investment at annual, monthly or daily compounding interest rate. You will also find the detailed steps to create your own E xcel compound interest calculator. In our example, the formula is =A2*(1+$B2) where A2 is your initial deposit and B2 is the annual interest rate. Please pay attention that we fix the reference to column B by using the $ sign. As you remember, 1% is one part of a hundred, i.e. 0.01, so 7% is 0.07, and this is how percentages are actually stored in Excel. Determine the interest rate (r). Before you can calculate how much you will earn, you need to know by what rate your principal will grow. The interest rate will be your r variable. Note that your r variable needs to be in the form of a decimal, not percentage. If you wanted to know how much of that $2323.01 is your earned interest, complete the following. Subtract your original principal from the number calculated in step Calculate the total amount of money in your account.. This page describes, and explains, with fully worked out examples, how to calculate the composition of a compound in terms of the % by mass of each element in a compound.  Calculate how much medication you need to make a certain number of doses. Total number of doses x mg per dose = total mg for compounding mixture. For example: 1  You need to dose your rat 2 times a day for 10 days with doxycycline (20 total doses). 2  The dosage prescribed is 4 mg. 3  20 doses x 4 mg per dose = 80 mg total. 4  Med balls-add 80 mg to recipe and cut into 20 balls. There are 2 methods to calculate accurate medicine balls. Calculate how many doses there are in one certain pill or capsule. Total Mg of pill divided by mg of each dose = the number of dosages per tablet/capsule. Each dose is a med ball. Here are some sample calculations: 1  100 mg Doxycycline /dosage of 2.5 mg = 40 doses. In this example, you'd enter the formula. To find out how much interest you actually earned with annual compound interest, enter the formula =B5-B1 (Balance after 1 year-Initial deposit) in cell C5. Then enter =B6-B5 (Balance after 2 years-Balance after 1 year) in cell C6 and drag the formula down to other cells. In our example, the formula is =A2*(1+$B2) where A2 is your initial deposit and B2 is the annual interest rate. Please pay attention that we fix the reference to column B by using the $ sign. As you remember, 1% is one part of a hundred, i.e. 0.01, so 7% is 0.07, and this is how percentages are actually stored in Excel. 150 mg ------------------ 300 mg = 1/2 tablet. Example 2: How many tablets containing 62.5 mcg will be required to give a dose of 0.125 mg? STEP 1: CONVERT TO SAME UNITS. Convert 0.125 mg to mcg. How to calculate tablet dosages: This formula is used to calculate the number of tablets to be administered when given the required dose. Required Dose ------------------ Stock Dose = Number of tablets to be given. Working Out How Many Periods. You can calculate how many Periods if you know a Future Value, a Present Value and the Interest Rate. Example: you want to know how many periods it will take to turn $1,000 into $2,000 at 10% interest. This is the formula (note: it uses the natural logarithm function ln): n = ln (FV / PV) / ln (1 + r). The ln function should be on a good calculator
http://www.wikihow.com/Calculate-Compound-Interest https://www.ablebits.com/office-addins-blog/2015/01/21/compound-interest-formula-excel/ https://www.ablebits.com/office-addins-blog/2015/01/21/compound-interest-formula-excel/ http://www.wikihow.com/Calculate-Interest http://www.docbrown.info/page04/4_73calcs04pbm.htm http://ratguide.com/meds/figures/compounding_medications_figure_1.php https://www.ablebits.com/office-addins-blog/2015/01/21/compound-interest-formula-excel/ http://www.testandcalc.com/quiz/testtabh.htm http://www.mathsisfun.com/money/compound-interest.html
how to figure out how many tablets to compound