Help me Please with this One!

B

Barbara Harris

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What if analysis, can this be DONE?? 1
Formula to another forumula? 10
Need help with formula 3
Range-name Behaviour 3
how to: have something equal Cx where x=8+ C4 9
Error Message - Input Range must be a contiguous Reference Help!!! 0
MATCH - HYPERLINK functions...COPY DOWN 2
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1

Top