How to use LOGEST function with data sets that has Blank cell

[kayyeah]

Hello!

I was wondering if anyone could help me with following example:

A1 B1 C1 D1 E1 F1 G1 H1
121 132 323 123 231 212

How can do the LOGEST function by using following at cell H1:

=G1*LOGEST(A1:G1)

Since there is a blank cell at E1, is there any way to forecast by omitting the cell E1?

Thanks a lot!
Jay

 

[kayyeah]

Thanks a lot!

And quite right, too! For it is indeed rather tautological ((IF(1,... is self-evidently TRUE).

However, its use in combination with N is quite necessary in this type of construction in order to coerce an array of returns from INDEX. See here:

INDEX: Returning an array of values « EXCELXOR

Regards