Excel Busn Math 14: Math Word Problems #2

I have created a graphed curve in excel based on data I have entered. I now want to take the formula for the graph, and use it as an excel computation where I can plug in X and get Y, or plug in Y to get X. However, when i try to enter in variations of these equations, I end up with just the wrong answers (based on the data that went into the graph to begin with.

The formulas excel gives me are these:

y = -1.1288x 3 + 23.209x 2 - 166.76x + 430.07 (preferred), or alternately


y = 579.38e -0.574x


So how can I enter this formula so that I can have it pull x from a cell and spit out the answer for y (and the reverse)?

I need a formula that does this. I have a base number of 300 seconds and want to add 30 seconds to it for every number over 1 so the output would be like this
input 0 and get 0 out
input 1 and get 300 out
input 2 and get 330 out
input 3 and get 360 out
input 4 and get 390 out
and so on. I can't for the life of me get the math down. Can someone please help.

I use a lot of math equations in my excel books. I would prefer to use correct symbols (primarily greek alpha characters) on the worksheet. Anyone have a useful and effective way of doing this?

Hello All,

I've search everywhere wondering of my example is even possible. In general, I'm assiting a friend's 8 year old daughter to study math. In school, paper wise they would receive something as follows: (WITHOUT the ANSWER 152). This is ony 1 example, there may or not be carry over number in 2 digit addition questions.

96
+56
152

What I would like to produce is the following:

1 1
9 6
+ 5 6
1 5 2

In cell reference above:
A3 +
B1 1
B4 1
C1 1
C2 9
C3 5
C4 5
D2 6
D3 6
D4 2

B1 & C1 are carry over numbers. generated by a formula, this is only one example. Addition could be of many different sequesnces of numbers.

Two things Im looking for, one the 1st number is entered, the carry over number appears above the question, likewise for the remaining columns to the left,

C2 & D2 are the first set of addition
C3& D3 are the second set of numbers to be addded to the first set.
B4, C4 & D4 are the answers the child would answer. The compliction of this is that the child just as with paper and pen would answer right to left

D2 + D3 would equal 12, the child would enter the last number 2, which leaves a remainder of 1 to carry which would appear in C1.

If the answer was not 12, then message X in all occurances of carry over.

C2 + C3 would equal 15, the child would enter the last number 5, which leaves a remainder of 1 to carry which would appear in B1. Giving the child the opprotunity to add C2 + C3 + the carry over C1 (obviously the formula I'm stuck on)

If the answer was not C2, then message X in all occurances of carry over.

Finally, the child would add up B1 which was the carry over from column C, leaving the answer of 152

I'm not sure if this can even be done, never mind devising a formula to create such a spreadsheet.

Thanks in advanced,
adulted (Paul)

I am new to Excel ,I am try to better my self.I would like to get a job as a mailclerk/data . I find excel to be easy in some parts & hard in others ""Math formulas,HARD""". I was never good at math so I am worry this will hurt me??

Hi, 1st time on this forum in desperation for help.

I have a spreadsheet which does a number of very simple calculations, but for a particular set of numbers, seems to lose the plot. I have a simplification of the problem here if you could look at it.

In A1 place number 7.02
In B1 place number 7.07
In C!, calculate the difference between A1 & B1 ( =A1-B1)
In D1, place number 0.05 ( this will be a limit that C1 becomes reportable)
In E1, do calculation. =IF(ABS(C1)>D1," out of calibration","")

My problem is that the calculation works for all values placed into A1 & B1 except for the above example. In the example shown, calculation in C1 = D1, but fails. For any other values of A1 & B1 which result in C1=D1, calculation works.
Am I going mad?
Thanks.....Peter

Is is possible to do complex math in Excel?

I can represent a number as a complex using the "=COMPLEX(A1,A2)" command. But I would then like to add, subtract, multiply or divide the complex numbers.

Thanks,

Raihnman

Well it don't do math all too good...
The trouble is because of this I get division by zero, which isn't really there.
At some point the value gets divided by itself, but the result is still busted!
And so are any subsequent results dependent on it!
So I was wondering - why does excel insist on using a value does has absolutely no impact in the long run.

...yet another stupid flaw in the system.

Here's the newest brain teaser:

I would like to be able to obtain round integers only from one number.

For instance, I want to be able to obtain the number
1,2,3,4,5,6,7,8,9,10 from the base number of 10.25

Sound like fun?

My only attempt thus far as I start this challenge is this:

=ROUND(A1*(((9/10)/10)*A1),0)

.... where A1 = 10.25 This will work out to 9 like I am attempting to
do, but has issues in that if the number (10.25) increases beyond 10.27
it rounds itself to 10, and beyond 10.5 it rounds to 10.5. Its a
problem with the 9/10's in there.

Consider this a puzzle and not so much an excel formula, though
knowledge in both is required... Im back to it....

Hi Folks,
here is the delima:
265,353 0.00
9,400 0
48,201 0
28,585 0
11,366 0
8,555 0
11,452 0
0 0
6,292 0
9,984 0

399,189 269,380

how can I weighted the column B according to column A and get the total of column B?
Any help will be appreciated.
thx