Bitcoin Forum

Economy => Services => Topic started by: Virtual Exchange on October 21, 2015, 07:54:30 PM



Title: Need Help With Excel (Paying Tips)
Post by: Virtual Exchange on October 21, 2015, 07:54:30 PM
Hi, I am having trouble figuring out how to use excel to calculate equations for loans, credit cards, and interest. If anyone can help me with this it'd be greatly appreciated and I will tip you. I am making tables and using the equations for the first couple periods and then dragging it down to fill the rest of the chart.


Title: Re: Need Help With Excel (Paying Tips)
Post by: Joel_Jantsen on October 21, 2015, 08:02:13 PM
How  is one suppose to help you ? Like through skype or do the work for you ? I'am sure this shady thread won't be enough for the explanation.I can give you a few suggestions though:

Download the ebook free :http://dl.upforfree.com/ebooks/Excel-Formulas-and-Functions-Fo-%20Dummies-3rd-Edition-ebooksfeed.com.pdf

This ebook has basically everything you need,just do the hard work of turning around the pages

Visit the youtube video and channel : https://www.youtube.com/watch?v=UI0gnZZHF1k He explains all the basics .Not exactly the stuff you wanted but you will get an idea .
Thank me later : )


Title: Re: Need Help With Excel (Paying Tips)
Post by: notlist3d on October 21, 2015, 08:05:15 PM
I would move thread over to services.  That is really where you hire jobs and offer jobs. 

You will find more people for jobs over there.


Title: Re: Need Help With Excel (Paying Tips)
Post by: lama-hunter on October 21, 2015, 08:27:52 PM
Hi, I am having trouble figuring out how to use excel to calculate equations for loans, credit cards, and interest. If anyone can help me with this it'd be greatly appreciated and I will tip you. I am making tables and using the equations for the first couple periods and then dragging it down to fill the rest of the chart.

i can help you with this. just pm me and i will give you my skype addy asap im online.

regards
lama-hunter


Title: Re: Need Help With Excel (Paying Tips)
Post by: TheButterZone on October 21, 2015, 09:18:43 PM
http://lmgtfy.com/?q=excel+to+calculate+equations+for+loans%2C+credit+cards%2C+and+interest


Title: Re: Need Help With Excel (Paying Tips)
Post by: Virtual Exchange on October 22, 2015, 04:49:20 AM
Figured it out. Had to type the Interest formula manually instead of referencing another cell.


Title: Re: Need Help With Excel (Paying Tips)
Post by: Vod on October 22, 2015, 04:56:51 AM
Figured it out. Had to type the Interest formula manually instead of referencing another cell.

Did you forget to use "$" to make the reference cell absolute?  I.E.  $A$1 instead of A1

That way the same cell will always be used.


Title: Re: Need Help With Excel (Paying Tips)
Post by: edgali on October 22, 2015, 05:04:25 AM
Figured it out. Had to type the Interest formula manually instead of referencing another cell.

Thats great sometimes the best way to learn is by trial and error,  now don't forget to document what you did.


Title: Re: Need Help With Excel (Paying Tips)
Post by: Virtual Exchange on October 24, 2015, 12:38:28 AM
Figured it out. Had to type the Interest formula manually instead of referencing another cell.

Did you forget to use "$" to make the reference cell absolute?  I.E.  $A$1 instead of A1

That way the same cell will always be used.

Yeah I used that symbol to freeze the values that were going to stay the same, but I must have forgot to freeze the cell I was referencing. I think it just wasn't in the right format.