Excel Busn Math 32: Markup & Markdown Math Problems

I have a total number that I would like to markup or down 0% to 100%. percent is set at 0,10,20,30,40,50,60,70,80,90,100, Deleate total from that cell = $0.00. also I would like to be able subtract the same percentage my choice up or down.
The 0% I would like it to say "Keep As Is" instead of 0%.
I will have several rows down all different totals, with a row to total all the rows.
lets say Colume A are those totals colume B would be the new totals up or down.
I don't know what to do at this point seems like a lot to ask of the cell to do.
Any ideas? Thanks

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.

Here's the deal...

Open Excel
New worksheet
Enter data
Sum data

No matter whether I add numbers from column to column or row to row, my
totals are always off by exactly 672. What the heck is that?!

Example...

A B C
140785 276714 418171

Formula in C is "=sum(A1+B1)

How much simpler can it get?

Any ideas?

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.

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

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

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.

I am using Excel to balance my checkbook. How do I enter a debit or credit in one column and then have the next column automatically display the new balance?

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