Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Use Excel in your rate card formulas to calculate discounts, ... For example, input the formula "=15*5" -- without the quotation marks -- to return the value "75." Advertisement.

To make it easier, Excel includes the RATE function with which you can figure out the periodic rate using information other than the APR. Begin by placing "=RATE ... For example, an $12,000 loan ...

CUMIPMT relies on the same three data points and many of the same variables as last time. When you enter "=CUMIPMT(" you'll see the following: =CUMIPMT(rate,nper,pv,start_period,end_period,type)So ...

You may be presented with year-end prices for a stock like this: 2021: $100; 2022: $120; 2023: $125; The price appreciated by 20% ($100 to $120) from year-end 2021 to year-end 2022, then by 4.17% ...

Calculating CAGR or Compound Annual Growth Rate in Microsoft Excel is super easy. You will have to use the RRI function to get the job done. ... Type =RRI(A7,B2,B7) as the function, for example.