Answered under your separate post (subject "Wht if analysis, can this be
DONE??") in the worksheet functions group. Please do not separately post the
same question to multiple groups.

Jerry

"Barbara Harris" wrote:

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?