Excel Busn Math 04: The Importance Of Formatting In Math

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?

DATE SPORT TEAM [B] [A],,[C] SPREAD MONEY LINE WAGER RISK TO WIN W/L/P DAILY PROFIT 3/8/11 NBA LA Lakers [A] -4.5 -110 $100.00 W 3/8/11 NHL Ottawa [A] +1.5 -120 $100.00 L 3/8/11 NHL Montreal [B] ML +140 $100.00 W

Guys i need your help. On th above example is a betting spreadsheet i am putting together. I want to enter the information above and have excel fill in the "risk" and the "to win" automatically by using the money line. I do not know how to get the number. If it is a "-110" or any other negative number it would be the wager*1.(what ever the number is...i.e. -140, -120, -175 etc). BUT the problem is what we call the "take back" if the number is +140 and you wager $100 and win you get $140.

So i just want to enter the moneyline and wager amount and have it figure risk and to win. And not to be greedy but is there is a "W" "L" or "P" i would like it to go into the daily profit column.

W=money won from the to win column
L=money lost from the risk column
P=nothing lost or won.

This is what i hope it to look like but with entering only the information from the wager column

DATE SPORT TEAM [B] [A],,[C] SPREAD MONEY LINE WAGER RISK TO WIN W/L/P DAILY PROFIT 3/8/11 NBA LA Lakers [A] -4.5 -110 $100.00 $110.00 $100.00 W $100.00 3/8/11 NHL Ottawa [A] +1.5 -120 $100.00 $110.00 $100.00 L -$110.00 3/8/11 NHL Montreal [B] ML +140 $100.00 $100.00 $140.00 W $140.00 Total: $130.00
L
I hope this makes sense. Thank you for your help.

i have a sheet set up to give me certain formulas for our payroll tax. for instance,
these are the numbers that show in the columns, they seem to rounded up on their own when needed, which is what i want.

column c = gross = 270.00
column d = Fed 15% = 40.50
column e = SS 6.2% = 16.74
column f = mc 1.45% = 3.92
column g = State 6% = 16.20
column i = Net = 192.65

the problem is this: i have a "Totals" column so that I know how much to send to the IRS each month. It does not add the rounded up figures "shown" but adds the un-rounded figures some how. the problem is that over time these figures are coming up wrong.

for instance, the mc 1.45% column shown above is actually 3.915. after several of these columns, my figures are wrong. take a look.

Date: gross: mc 1.45% shown in cell mc 1.45% actual

3.1.07 1000.00 14.50 14.50
3.5.07 270.00 3.92 3.915
3.12.07 100.00 1.45 1.45
3.19.07 50.00 .73 .725
3.26.07 50.00 .73 .725

totals 21.32 21.315

it gets worse... if you add all of the "shown" mc column, it is actually 21.33

here is the formula i am using for the "Total MC 1.45%" cell =SUM(F3:F60) now i have another problem, i am suppose to match the s.s. tax and the medicare, so i have another cell that is suppose to simply multiply the "Total MC 1.45%" cell by 2. here is the formula i use for that cell. =K10*2 it says that 21.32 x 2 = 42.63 this is how i discovered this mess in the first place.

i hope this is understandable, as i know it's a bit hard to explain without seeing it. any help would be really great, as this is my first month to begin doing this and i need to get this thing right.

thanks in advance.

Hi team,

I have the below table and want to produce a figure that will show a rolling
target.
ie: the target for 12 months is 13... for one month someone gets a score of
11. what will be the target score next month to bring them back on target to
end up with 13?

Date TRUE CALLS score to get avg of 13
20/1/2006 11.91
3/2/2006 11.23
17/2/2006 11.33
3/3/2006 11.35
17/3/2006 11.41
31/3/2006 11.60
14/4/2006 11.91
28/4/2006 11.78
12/5/2006 11.68
26/5/2006 11.55
9/6/2006 11.57
23/6/2006 11.58
7/7/2006 11.55
21/7/2006
4/8/2006
18/8/2006
1/9/2006
15/9/2006
29/9/2006
13/10/2006
27/10/2006
10/11/2006
24/11/2006

Your help is much aprieciated

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

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??

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)