Excel Busn Math 01: What is Excel?

I want to create a function which defines a pulse wave that rises from
0 to 1, stays at one for a bit, lowers to 0, and stays at zero for a
bit.

/ if (t mod 1) <0.25, V(t) = 4* (t mod 1)
| if 0.5 >= (t mod 1) > 0.25, V(t) = 1
V(t) = |
| if 0.75> =(t mod 1) > 0.5, V(t) = 1-4* (0.75-(t mod 1))
\ if 1 > (t mod 1) > 0.75, V(t) = 0

For this pulse wave there are straight rises, falls and flat bottoms
and tops, which I need (and which is why a sine wave can't be used). If
you're still with me, thanks.

I can either put this all into a long excel equation for each cell that
I want this in (there will be about 4 'if' statements and 6 'mod'
statements) or create a UDF, where the t mod 1 only has to be
calculated once.

Any idea out there how much faster/ slower as UDF really is in a case
like this? Also, can you think of an easier way to create this pulse
wave?

As a side note, the t in my program has some ROW() and COLUMN()
dependence, and there will be 200+ cells filled with this equation
(thus, I can't just compute it once and copy the values to each cell).
Caculation speed is important because each cell is being calculated as
the time, t, is advanced by a timer.

Thanks in advance to anyone who takes a stab at this.

-Abe

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.

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.

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

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

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.

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.

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)

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?