Current Position:Home > Convert mathematical formulat to excel formula

Convert mathematical formulat to excel formula

Update:11-30Source: network consolidation
Advertisement
I have a formula that was generated by excel when using a trendline on a graph. I need to convert this formula into an excel formula I can use again.
the formula is below. Assume that the value for X will be in Cell A1. Any help converting this to an excel formula would be awesome. FYI = for a X value of 20,000, the formula should output something close enough to 20,000 ( +- 5 or 10k).
y = 1.8932x6
- 116.85x5 + 2669.5x4
- 27947x3 + 140531x2
- 298100x + 199955

The Best Answer

Advertisement
Test the result according to the formular that you provide initially and get the result 16993.54 (B2=1) which it is should be.
=1.8932*B2^6 -116.85*B2^5 +2669.5*B2^4-27947*B2^3+140531*B2^2-298100*B2+199955
(The fomular you provide last time is different from your initial request.)
Cheers,
Tony Chen
Forum Support
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please contact
[email protected]
  • Convert mathematical formulat to excel formula Update:11-30

    I have a formula that was generated by excel when using a trendline on a graph. I need to convert this formula into an excel formula I can use again. the formula is below. Assume that the value for X will be in Cell A1. Any help converting this to an

  • How to convert an Excel Formula to a Custom Calculation Script in a Adobe Acrobat 9 Form? Update:10-11

    Hello, I am not familiar whatsoever with Javascript and need some help in converting the following Excel Formula so that I can enter it into a Custom Calculation Script in a Adobe PDF Form. Here is the formula: =IF(E15<25.01,9.95,IF(E15<50.01,11.95,

  • Numbers Equivalent of Excel Formula for Converting HH:MM:SS to DD:HH:MM:SS Update:11-30

    I am not sure if this has been asked before. What would be the Numbers formula for converting HH:MM:SS to DD:HH:MM:SS?  The Excel formula is entering 396:59:45 into a cell and then in another cell is the following =TEXT(A2,"dd:hh:mm:ss").  The A

  • Converting Excel formulas in Numbers Update:11-30

    I am new to Numbers and have an Excel Spreadsheet that I've used previously that calculates the best 4 scores from golfers over a 10 week period. In Excel I used =sum(LARGE[e2:n2,{1,2,3,4}]) but when I use it in Numbers I get a Syntax Error message.

  • Converting excel formulas to javascripts Update:11-30

    Hello, I am not experience in Excel formulas and creating "if" statements in Adobe Acrobat, so I'm hoping someone can help me with this. I have two problems. 1.  Here is an excel formula that I need to convert over to javascripts. Can someone he

  • I want to convert this excel formula into a formula that works in Numbers =INDEX(Codes!$B$1:$B$9998;MATCH(TRUE;ISNUMBER(SEARCH(Codes!$A$1:$A$9998;'Curren t Account'!E4358));0)) Update:11-30

    I want to convert this excel formula into Numbers formula =INDEX(Codes!$B$1:$B$9998;MATCH(TRUE;ISNUMBER(SEARCH(Codes!$A$1:$A$9998;'Curren t Account'!E4358));0))Without knowing the structure of the spreadsheet, or what e3xactly you are trying to do, i

  • I need help converting an excel formula to javascript for a fillable form. Update:11-30

    Here is the scenario, If a person travels for 1 or 2 days we pay out a mealsrate of 75% per day. If 3 or more days we pay # days less 2 days * 25%. I hope that makes sense. V7 = Days, F14 = Mealsrate Formula in Excel =IF($V$7 = 1,$F$14*0.75,($V$7*$F$

  • Excell Formulas to Javascript Update:11-30

    I just got a request to convert an Excel file to PDF, and make the form calculate.  The calculations are pretty complex (at least to me they are).  There are four different types of formulas needed.  I've copied the information below.  Can someone he

  • How can i convert oracle report in excel format using 8i Update:10-11

    hi, I want to convert oracle report in excel format using 6i reports. please give the solution with emp table. millons of thanks in advance.You'll have to use the destype DELIMITEDDATA to render your Report in CSV format. Then set the mime type to Ex

  • How can I convert word labels to excel Update:10-11

    I have just purchased this Adobe ID program and paid for a years subscription. Can someone tell me how I can take Microsoft word 2010 labels already saved on my flash drive and convert them to an excel spreadsheet with headers such as: Name