LinkBack URL
About LinkBacks
Hello,
I have $380,000 in year 4 and $180,000 in year 1 how do I calculate the cells in between to reach that $380,000 number?
Thanks,
Max
Hello,
I have $380,000 in year 4 and $180,000 in year 1 how do I calculate the cells in between to reach that $380,000 number?
Thanks,
Max
Assuming:
- you need one number per year
- 180000 is in A1
- 380000 is in A4
In A2 put:
Formula:
Please Login or Register to view this content.
and fill down/copy into A3
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
How are you looking at making the jump from year 1 to year 4? a straight even increase?
are we talking year by year, month by month, week by week, day, by day?
how many cells are looking at?
perhaps you could upload a sample workbook with an example of what you're looking to achieve at the end?
Awesome, thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks