Variable inputs to Linest

**scavia** · 07-15-2023, 05:35 AM

Hi,

I'm trying to assign variable ranges as input to Linest, using 2 independent variables. The following code fails. I'm sure this is something simple, but Im stumped.

Please Login or Register  to view this content.

**davesexcel** · 07-16-2023, 03:38 AM

You would not have to activate the ws, but qualify the range.
For example
Notice "with" and the period

Please Login or Register  to view this content.

**scavia** · 07-16-2023, 06:03 AM

Thank you. I figured it was something straightforward

Variable inputs to Linest

LinkBack

Thread Tools

Rate This Thread

Display

Variable inputs to Linest

Re: Variable inputs to Linest

Re: Variable inputs to Linest

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Blank column as x variable & LINEST()

Adapting LINEST Muliti-variable regression - change one variable to be Logarithmic

[linest] Whu LINEST can't the precise parameter of each variable?

[SOLVED] Variable number of lines in a Linest

Using linest for a variable range

Formula with 3 variable inputs

[SOLVED] Passing Variable to LINEST

Bookmarks

Bookmarks

Posting Permissions