AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

Interest in Excel
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
Posted 4/18/2022 13:53 (#9619522 - in reply to #9609312)
Subject: RE: Interest in Excel

I tried opening the .xls file in Excel on my phone and it did not like the formulas. I exported it as a .xlsx file that does seem to work on my phone. Basically the dates are generated using a month offset from the start (=EOMONTH($B$6,A6)+1) where $B$6 is start date and A6 is month in series (column A). I included another sheet which I use to keep track of interest on my loans, one sheet per loan. It is pretty much same as sheet 2, except it allows information to be copied in as it happens rather than defining a date series from the start.

Attachments InterestCalc.xlsx (18KB - 2 downloads)
Top of the page Bottom of the page

Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)