Excel Busn Math 52: Markup & Markdown

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 am trying to insert a formula to calculate a percentage of margin/markup.
Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price
is 10.00. Can anyone help with this formula?

HTML markup to add comments to excel cell

Hi,

I want to create an html string such that if I just paste that html string
into an excel sheet it will add a comment to one cell. Something like:

<table>
<tr>
<td ss:Comment="This is my comment text">my cell text</td>
<td>another cell</td>
</tr>
</table>

In the above example the text "This is my comment text" should become
a comment in the excel cell with text "my cell text".

Is this possible? If so, what is the markup to use?

I know that I could use something like the code below to add comments, but would rather not.

<div style='mso-element:comment'>
<div>
<!--[if gte mso 9]><xml>
<v:shapetype id="_x0000_t202" coordsize="21600,21600" o:spt="202" path="m,l,21600r21600,l21600,xe">
<v:stroke joinstyle="miter"/>
<v:path gradientshapeok="t" o:connecttype="rect"/>
</v:shapetype><v:shape id="_x0000_s1025" type="#_x0000_t202" style='position:absolute;
margin-left:107.25pt;margin-top:1.5pt;width:96pt;height:55.5pt;z-index:1;
visibility:hidden' fillcolor="#ffffe1" o:insetmode="auto">
<v:fill color2="#ffffe1"/>
<v:shadow on="t" color="black" obscured="t"/>
<v:path o:connecttype="none"/>
<v:textbox style='mso-direction-alt:auto'/>
<x:ClientData ObjectType="Note">
<x:MoveWithCells/>
<x:SizeWithCells/>
<x:AutoFill>False</x:AutoFill>
<x:Row>0</x:Row>
<x:Column>1</x:Column>
<x:Author>23059278</x:Author>
</x:ClientData>
</v:shape></xml><![endif]-->

<div v:shape="_x0000_s1025" style='padding:.75pt 0pt 0pt .75pt;text-align:left'
class=shape><font class="font6">23059278:</font><font class="font5"><br>
This is my comment</font></div>
</div>
</div>

Any help is greatly appreciated!

Regards
/Christoffer

Have a column that contains something I can't see. It's causing that entire
column to register when exporting to a different database. I can't find the
culprit - am guessing it's a tab or a line break that's in one of the cells.
In Word, I can view formatting marks. Is there a way to view those in Excel
so that I might find this rogue entry in a cell?

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

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.

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)