Author Topic: Help needed to convert Excel Formula for use in condition  (Read 369 times)

Tags:
  • All members
  • Posts: 31
  • Karma: +0/-0
Help needed to convert Excel Formula for use in condition
« on: Mon, 16 April, 2018, 12:13 »
y = 1.2999e-0.055x is the formula for an exponential trendline in an Excel chart.
I want to use it in a condition where Y < 1.2999e-0.055x

The -0.055x is 'to the power of' but it disappears when posted


Please can someone show me how do I write it for MFP to interpret it correctly?

Thanks
Moose

  • All members
  • Posts: 28
  • Karma: +0/-0
Re: Help needed to convert Excel Formula for use in condition
« Reply #1 on: Tue, 17 April, 2018, 00:05 »
I had a similar problem and unfortunately it looks like exponential functions are not implemented in MF Pro.

What I did was the following thing:

I plotted data points of the exponential function in OriginPro and found a best fit to the data set using a different power function that does not use e.

  • Moderator
  • Posts: 2823
  • Karma: +232/-0
*
Re: Help needed to convert Excel Formula for use in condition
« Reply #2 on: Tue, 17 April, 2018, 05:49 »
Hi
if your MFP session is linked to an Excel spreadsheet where the functions are being calculated you can use the cell values in a trigger expression, for example:
selections trigger expression cell_Sheet1_A2 is less than cell_Sheet1_A1
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 31
  • Karma: +0/-0
Re: Help needed to convert Excel Formula for use in condition
« Reply #3 on: Tue, 17 April, 2018, 10:06 »
Thanks Markv and LiAlH4.
I'll try your suggestions

Moose