How to Calculate Radioactive Decay in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

The rate of radioactive decay is measured by an isotope's half-life, which is the time it takes for half of a radioactive isotope to decay into a different isotope. This means that after the half-life period, only one-half of the isotopic material will remain. Although the concept is simple enough, the formal formula is slightly more complex, because it involves natural logarithms. To simplify the calculation, you can create an Excel spreadsheet to run the numbers for you.

Advertisement

Step 1

Open Microsoft Excel.

Video of the Day

Step 2

Enter the isotopes half-life in cell "A1." Half-life can be any unit of time, such as microseconds or years. However, to keep units consistent, use days. To convert years to days, multiply by 365.25 with the formula "=years_325.25". To convert seconds, divide by (24_60_60) with the formula "=seconds/(24_60*60)".

Advertisement

Step 3

Enter the length of time, for which you wish to measure the radioactive decay, in cell "A2." Use units of days.

Advertisement

Step 4

Enter the formula "=EXP(-LN(2)*A2/A1)" in cell "A3." The answer gives you the fraction, in decimal form, of the remaining isotope.

Advertisement

Step 5

Right-click cell "A3," select "Format Cells", click "Percentage" in the Category list of the Number tab, and click "OK." This converts the answer into a percentage.

Video of the Day

Advertisement

Advertisement

references