Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Statistical functions to calculate exponential trendline

ray78
New Member

Hi, I am relatively new to app sheet. Would like to know if there is a way to calculate exponential trendline for values in a table based on conditions.

Basically, to obtain results fm the equation : y =aEXP(bx) where
a: =EXP(INDEX(LINEST(LN(y), x), 1, 2))

b: =INDEX(LINEST(LN(y), x), 1)

0 2 311
2 REPLIES 2

Steve
Platinum 5
Platinum 5

There is no LINEST() equivalent in AppSheet.

Thanks Steve.
Is there any work around to calculate exponential trendline

Top Labels in this Space