The number of periods is the time in years multiplied by the periods per year (t × ppy). The time in years is in cell B6 and the periods per year is recorded in cell B4. In cell B7, the number of periods is given by this Excel formula:
=B6*B4
