• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

About Percentages

Many financial calculations involve percentages for values such as interest rates and fees. A percentage is one-one hundredth, so when you write 2%, you really mean 0.02. In all of the templates, I have used Excel’s percentage format for those cells that contain percentage values. This format handles percentages beautifully, not only displaying them with a percent sign but taking care of the conversion.

For example, if you enter the value 2 in a percentage cell, Excel assumes you mean 2%, displays the number as a percent (such as 2.00%), and uses the correct value, .02, in calculations.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint