Hi All,
Refer to below sample data
A2:A12 - contains the data or lookup number
B2 - contains % increase
C2:C12 - contains the result
In summary, what I'm looking for is some mathematical formul athat will yield the result in Colmn C if a numbe rin column A is selected without using a lookup formula to reference a table as I'd like to remove the table
Example
Say in A1 the number 6 is selected then in Cell B1 the result would be 1.077
A
B
C
1
DATA
%
RESULT
2
1
1.50%
1.000
3
2
1.015
4
3
1.030
5
4
1.046
6
5
1.061
7
6
1.077
8
7
1.093
9
8
1.110
10
9
1.126
11
10
1.143
12
11
1.161
Spreadsheet Formulas
Cell
Formula
C3
=C2*$B$2+C2
C4
=C3*$B$2+C3
C5
=C4*$B$2+C4
C6
=C5*$B$2+C5
C7
=C6*$B$2+C6
C8
=C7*$B$2+C7
C9
=C8*$B$2+C8
C10
=C9*$B$2+C9
C11
=C10*$B$2+C10
C12
=C11*$B$2+C11
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.
is there a keybord sortcut to increase or decrease decimals
Many thanks
Pierre
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.
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
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?
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?
Need help to create a formula that will, first multiply the value of two cells, then divide by 3600 & multiply the answer by a certain percentage depending on which range the answer falls into. eg.
If 2100 (A1) x 210 (B2) divided by 3600 falls between 1200 & 1400 then multiply by 110%, if answer falls between 1000 & 1200 then multiply by 112%, if answer falls between 900 & 1000 then multiply by 114%.
Thank you in advance for any assistance.
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.
