Calculation of NPV in Spreadsheet and connected to Access form for

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access form that asks the user to input all the pertinent data
(periods, tax rates, discount rates, depreciation, economic life etc) into
the access database. Can I use an excel spreadsheet to calculate NPV and
then have the Access form pul the result from the spreadsheet? Thanks in
advance for your help!

Linda
 
Linda,

Any calculation that you can do in Excel can be done in an Access form.
Simply add another text box to the form, then type "=" and the calculation
in the recordsource property.

HTH,
Josh
 
Back
Top