Free Microsoft Excel 2013 Quick Reference

- Formula to solve for "X"
- Formulas: How do I solve for x in 4th order polynomials.
- Solving for X and Y with a = in the FUNCTION???
- Solving a formula for X
- Erlang C (m, u,), solve for m
- Excel formula to solve a mathematical issue
- Compare value against list and return X if no match
- Solver question... setting up formula...
- Formula assistance
- If / then statement with range of greater than or equal to
- Formula using four inputs - help
- How do I solve for x in a second-order polynomial trend?
- Solve function for X when result and Y variable are known
- Solving for combinations
- Dont know the right formula to use
- Is this possible to solve with array or count or countif formula?
- Solving a formula
- How do I solve for complement rule of P(X > or = 4.0) in excel?
- Logarithmic equation with data points
- Useing a Logrithmic y=intercept in a cell

The equation is as follows:

0.05004 = (x - 48.78)/x

I can't figure out the formula to solve for x. I know what the value of "x" is but I want excel to do it for me. (x = 51.35)

Thanks for any help.

Using x and y plotted data, I am able to generate a 4th order polynomial trendline. Using the LINEST function, I can express the coefficients (A,B,C,D and E) in cells on my spread sheet. My question is, if I have a known y value how can I solve for x? This is something I could of course do on my TI-85 calculator, but I would like to be able to do this in excel. I do not know if this is possible as it is an iterative process. Any help would be greatly appreciated.

Thank you in advance!!!

A (-6,-4)

B (-1,8)

C (13,-2)

Find the point perpendicular to AC.

y-y1=m(x-x1)

For this equation, it is solved

y+4=2/19(x+6)

y=2/19x-64/19

y-8=-19/2(x+1)

y=-19/2x-3/2

Therefo

2/19x-64/19=-19/2x-3/2

365x=71

x=.195

..195 is substituted back into the orginal formula to find for y.

I know to use the x and y variable to have the function call out a cell with

either the x or y in that cell, what I believe is screwing up the function is

the = sign in the middle of it. Any suggestions?

A1=350

B1=.29385

C1=1500

D1=100

X should be 49.6%

I need to find a way to solve for x in a cell and replicate it into hundreds of cells, I don't know how I would do this with a some function/formula

i have the formula written as

poission(m,u, false)/(Poisson(m,u,false) + (1-p) x Poisson(m-1,u,true))

how would i rewrite this formula to solve for # of staff needed, if i plugged in the probability of wait along with all the other variables??

I have a mathematical issue I would like to solve using Excel.

The column A shows 3 values (e.g. 1, 2 and 3 but countless combinations are possible). The column B shows 3 unknown quantities (x, y and z). I need to find the value of x, y and z in order to get contemporaneously positive values in C1, C2 and C3. Is there a way to create an excel formula which can help me with that?

Please check the attachment to get more info.

Thanks in advance for your help!

I have a problem here that I have been trying to solve for almost a week now, I hope someone can help me with this. I am just new to excel so please bear with me

I have a list of questionnaires at the left side of column "mark down", If an answer is given incorrectly to the question an "x" mark will be graded with a corresponding "comment". What I wanted to do is to create a formula that will get all the "comment" and place it in the "summary" box to the right.

The excel file looks like this. Hope someone here can help me, I am already going crazy on this. Big thanks

A1/B1 = x (T/Y)^p (M-l/E-l)

i have A1, B1, T, Y, M and E but want to see what the best values for the other parameters are.

^ = exponent

can someone please help an old fool?

I have posted this question in the more appropriate formula assistance

forum, but since it seems infrequently visted compared to this forum, I

thought maybe someone here could offer some advice.

I have several employees that work for me at $7.00 per hour. They want to

work more hours per week at this same wage, but I am unable to afford

overtime for them.

Department of labor laws state that every hour over 40 per week must be paid

at 1.5 the normal hourly rate. My employees have agreed to take a cut in pay

to enable me to pay them whatever amount is necessary if, when overtime is

applied, they average out to $7.00 per hour. In other words, they are

willing to work for 40 hours per week at x amount and a variable number of

hours for x*1.5 as long as the x +(x*1.5) averages $7.00 per hour.

This number x will change with each schedule since they will work a

different number of hours per schedule (ie an employee may work 55 hours in

week one, 50 hours in week two, 60 hours in week three, and so on). Can

anyone help with a formula that will solve for x based on these changing

hours with the average rate of pay still staying at or around $7.00 per hour?

Thank you,

Brad in Dallas

If X is greater than or equalt to 3.50 . . . then the answer is 1

If X is greater than or equal to 3.00 and less than 3.50 . . . then the answer is 2

If X is greater than or equal to 2.50 and less than 3.00 . . . then the answer is 3

If X is greater than or equal to 0.00 and less than 2.50 . . . then the answer is 4

Thanks!

need to back-calculate for an adjusted point, using the basic formula y= ax^2

+ bx + c.

I'm horrible at formulae in excel!

My name is Ashraf, i am new here and new in excel, i hope to find help here,

I have formula with two variables equation X and Y, the result equal one, so i want to find

X if the result equal 1 and we know y, the formula is: = 1.00721*sin(0.00819674/(y - x) + 46.5323*y - 48.572*x)

is there any function in excel to revers the formula to find the unknown equation?

[=OR((AA3>AB3),(AF3>AG3),(AK3>AL3),(AP3>AQ3),(AU3>AV3),(AZ3>BA3))]

In the above formula, I get a "true" if the value on the left of the "> sign" is greater than the one on the right of it in one or more of the parenthetic groupings. What I need is to change the formula to give a "true" if the left variable is greater than the right one in at least 2 of the parenthetic groupings. It doesn't matter which two, just that the "(cell x > cell y)" in at least two of these groupings.

Any help on setting this up would be greatly appreciated. Or, if you can give me a tip on what I am asking for in terms of Excel-speak so I can look for it myself, that might be enough.

Thanks.

Ultimately I am trying to create a formula that would answer the following question:

-For the month of X, whats is the ROI for marketing bucket Z

-To put it more concretely: For the 3d month of 2011, what is the ROI for marketing bucket SEM

So the steps I would follow are:

1) In a cell, I enter the following value "SEM"

2) In a different cell, I enter the following value "1/2011"

3) Excel takes the value SEM, goes to spreadsheet ZTM, searches for all rows that are labeled SEM Revenue and SEM Cost

4) Then, Excel would calculate (REVENUE - COST) / COST, but the values it would use for the calculation are the values that are located under the column for the month of January, 2011. So that if I needed to calculate ROI for SEM for 2/2011, I could simply just change the data in step 1 and step 2.

I hope I am being clear in my explanation….

I was going in the direction of a SUMIF formula with an OFFSET function embedded in it to limit it to only the months needed for the calculation.

90 guys, each has his own spreadsheet recording events for 3 years.

Each spreadsheet has a date (eg., jan 2012).

Eg.

------ John Peter Steve Eric...90th guy

Jan-----28---26----46----39

Feb-----36---39---29-----82

... 3 years

This is for about 90 guys, each with abt 9 sheets x 36 months each person = ineffective to insert formula to find month for countif() month method, and I happen to be weak in array formulas.

Is there an array formula that I can use to complete the table above?

Eg. Countif(b:b,'=jan-2011') returns 28 for John, and so on.

(problem now is, all dates are in 1-jan-2012 format, so I don't have the "jan-2011" value ready to work on. Again, doing a formula to get all the months' worth of "jan-11" is too ineffective. Pivot table doesn't help either!)

Appreciate that this is a messy table, will be home soon to make an excel example!

of P6 ( I have different values of P6 (P7, P8, P9 (reference cells)). I need

the value of x for the different values of P6. Is this possible? It seems

like it should be but I can't find out how to make Excel do this. Please

help! Thanks.

70000 = P6*((((x/80)*(1/5280))*(2/3))+(((x/40)*(1/5280))*(1/3)))

standard deviation of 1.1 years. Suppose also that exactly 30% of the tubes

die before 4 years. Find the mean lifetime of TV tubes. Carry your

intermediate computations to at least four decimal places. Round your answer

to at least one decimal place.

My question is: (a) how do you solve in excel for complement rule of P(X >

or = 4.0).

(b) How do you solve a z-score of -0.2533 to produce a mean of 4.7787 in

excel?

I have tried to find a function or formula that I can use to determine

similar outcomes.

Okonita

I am a student taking a statistics class and I have this homeworks problems

to solve and I'll love to use excel to do this but don't know how?

How can I post this function into a cell:

y = 16.899Ln(x) - 11.928

This is the Y-intercept from a tredline. If you right click a line in a scatter chart, you can click "show trendline". Under trend line, you can ask it to display the formula. That is where I got this formulla. So, I want to put this into a cell so I can "drag" it down to solve for X.

I.E. With a standard (non logrithmic) line my formula looks like this:

y = 0.4121x + 13.416, which I translate into the cell to this:

=0.4121*B5+13.416

From that I can drag it down to fill in the blanks.

Now, I cant do this with the logrithmic line, becuase I havent figured out how to paste the function for "Ln"

Anyone know how?

No luck finding an answer? You could always try Google.