ASP.NET Spreadsheet Component Calculation Sample
Using C# and SpreadsheetGear
Loan Calculator
Loan Amount (pv)
Interest Rate (rate)
Total # of Periods (Nper)
Payment $923.58

Notice These Features:
  • Parses inputs, including currency, percent, date, time and fractions.
  • Allows simple or complex formulas - Enter "=1% * 12" for Interest Rate (don't include the quotes).
  • Returns nicely formatted results, including all Excel custom formatting options.
  • Uses defined names to access cells (see the source code and workbook).
Copyright 2005 © SpreadsheetGear LLC. All Rights Reserved.