Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Help me if anyone can!
I set up the function Trend(C1:C5). From this the function returns the Linear regression value for the latest data point C5. How can do a what if analysis to find the value at C5 that equals the Linear regression value i.e., solve for C5= Trend(C1:C5)? Any way it can be done? |