I need to create the slope of function of relationship between time and price. I am trying to make it between the two most recent days. On the 'Analysis' sheet, the cell I have been trying to do this in is K5.
Please see formula by JBeaucaire in cell I5. I wasn't sure how to break it down to do this next step. Here was my original thread: http://www.excelforum.com/excel-form...ml#post4190426
Would anyone be kind enough to help me out?
I've attached my work. Thanks very much.
Bookmarks