equation

I am trying to calculate a rate and am getting a rate of 1200%, so clearly I have a mistake in my equation but can't figure out where. Here is my statement...

Hi all, I'm new so hopefully I posted to the correct forum. I'm trying to extract the coefficients from an equation of an exponential graph, hoping to eliminate the manual process which requires me to key the numbers into a cell. What I noticed, however, is that the displayed equation from...

Hi All, Looking for help creating a formula for an equation. I'm not very good when it comes to this so any help is appreciated, thanks! For simplicity sake, the following values are below: MW = Cell A1 A = Cell A2 VP = Cell A3 T = Cell A4 V = Cell A5 (Delta)x = Cell A6 p = Cell a7 Vx =...

Hi, I have the following equation which seems to not be working - and I'm not sure why, if someone could please help =SUMIFS('Apr-18'!$CU:$CU,'Apr-18'!$AJ:$AJ,"*"&B4&"*") - doesn't work =SUMIFS('Apr-18'!$CU:$CU,'Apr-18'!$AJ:$AJ,"310003") when I change the B4 to be the actual cell contents of...

Help!!!! I have copied the folowing equation from a different spreadsheet. I did not know how to write it myself. Current equation if cell f23 =if(and(isnumber(d23),d23>0,isnumber(e23),e23>0),d23*e23,if(and(isnumber(d23),d23>0,istext(e23)),"tbd",0)) right now if cell d23 is blank then cell...

I was thinking those who are skilled in excel often have a mind for math logic as well. Perhaps you can help me finish this equation? I am trying to calculate the live percentage difference between two targets in the cryptocurrency market in relation to realtime price changes. Entry: .02...

Hi there! I'm fairly new to VBA and am stuck with a process. I have a few scattered graph on excel and was wondering if there are any methods to filter data based on equation using VBA? Let's say I want to filter data points that is above the y = e^x curve, is it possible to do so?

Dear all, Feel thankful to find this forum. I'm not an excel expert, nor a math expert. But recently I have to find the X value with this equation: Y = 0.0000302307X^6 - 0.0017620175X^5 + 0.0376232469X^4 - 0.3880372117X^3 + 2.3962783035X^2 - 3.6979108034X + 1.4580209629 I have a series of Y...

I have a formulae that if its doesn't meet certain conditions that it returns a blank ,"") the odd thing is as I run the loop and collect the data with each passing by a simple equal equation if the cell was blank it returns an apostrophe in the cell like this ' Any idea as to why this is...

I have two data points in my data, a and b and I am trying to forecast point c. Assuming a linear relationship, surely point c would be: (b-a) + a However if I use Excel's linear forecast function in the graph, I get an equation that does not give me the same figure. In my data, a =...

All, I have created a name in the name manager I called it "l3nox". The data can be pulled how ever I want it to so the amount always changes. I then graph the data based on the name I have defined. Here is the equation for my name. =Sheet1!$F$6:INDEX(Sheet1!$F:$F,COUNT(Sheet1!$F:$F)) For...

Need VBA code to convert for the following Excel worksheet equation: =Trunc((D26/B26)*0.96),1)

Hi, I fit a polynomial line to a chart and got the following equation: -5E+06x^2 + 7E+07x + 1E+08 How do I use this as a formula in a cell? Thanks Jeff

Hi, How could I use *just* formulas to solve for "X" in the following algebra equation in Excel? (58.9806-x)/(195.3-x) = .1 Thank you in advance for any assistance.

Hello good people, I'm trying to copy and paste a log trend line from a chart into a cell. A sample equation is as follows: y = 0.0083ln(x) - 0.0902. As I run the regression for different datapoints, the equation constantly changes. Hence, I'd like the macro to copy and paste the equation into...

Hello All, First post on this forum. Just to be clear, I have already searched similar threads (here and and elsewhere) and tried to piece together a VBA code that will work, but I just don't have the adequate experience under my belt to write a executable code. I have a maybe a thousand...

Hello, I have been searching and trying all sorts of dynamic array formulas that will eliminate out the blank cells from a list that populates based on user input, but haven't had a lot of luck. I have currently this equation...

Hello! I'm trying to get an equation to work for a peppercorn blend form I have, where changing cell B2 from Gram to TSP (teaspoon) will change the output in the Total cells. See below for the form. TSP Field Selected - https://i.imgur.com/FIHDDor.png Gram Field Selected -...

I have a scatter plot with 2 data sets plotted which can be updated from a userform. On the form in 2 labels, I update the caption to a projected value from the trend-line equation. When I step through this part of the code, I can see the trend-line equation from the object being pulled...

In a1 i have a variety of single variable equation such as : -3 -6x = -15 .... I need a way to separate the three parts in the next three columns showing the following: b1 "-3" , c1 "-6x" and d1 "-15" the other type of equation is where the <tbody> x variable is at the front such as 3x +4...