logest

  1. K

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

    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...
  2. D

    Using Logest function within a Pivot Table

    Hi, I'm having some problems trying to use Logest() function as a formula to a calculated field in my Pivot Table. The native fields of pivot table must be part of the array used as input to Logest formula. In normal tables i would simply use =logest(A1:D1). But when trying to create an array...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top