Timeline for Formula for calculating cost over a certain time period
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 25, 2014 at 16:58 | comment | added | iliketolearn | Yeah I did that. What I meant by "manual" was making up the formula logic. I wasn't sure if there's was already a function or if this is the proper way to do this. | |
| Feb 25, 2014 at 15:59 | comment | added | Doug B | Fill in each of the first 5 rows of Column A with incrementally increasing numbers (Cell A1 = 1, Cell A2 = 2, Cell A3 = 3, etc) to give number of years. In Column B put in your first equation into Cell B1 reading "=30000+3000*A1*12". Copy and paste this cell into Cells B2, B3, B4 and B5. In Column C put in your second equation into Cell C1 reading "=40000+2000*A1*12". Copy and paste this cell into Cells C2, C3, C4 and C5. You can then create a graph to show where one crosses the other. | |
| Feb 25, 2014 at 14:14 | comment | added | iliketolearn | Is there a specific excel formula I should use? | |
| Feb 25, 2014 at 13:35 | history | tweeted | twitter.com/#!/StackProjects/status/438306357100699650 | ||
| Feb 24, 2014 at 21:01 | comment | added | Doug B | Why can't you just use Excel formulas? | |
| Feb 24, 2014 at 17:37 | answer | added | Guido Leenders | timeline score: 2 | |
| Feb 24, 2014 at 17:05 | review | First posts | |||
| Feb 25, 2014 at 5:15 | |||||
| Feb 24, 2014 at 16:49 | history | asked | iliketolearn | CC BY-SA 3.0 |