Excel Busn Math 49: Markup On Cost

I searched everywhere but couldn't find anything like this. I will try to simplify this as good as i can.

I will have one column with different $values, which is the cost of my products. My markup will be as follows.

0-.69 * by 900%
.69-100 * by 800%
1.00-2.00 * by 700%
2.00-3.00 * by 600%
3.00-4.00 * by 500%
4.00-5.00 * by 400%
6.00-10.00 * by 300%
10.00-20.00 * by 200%
20.00+ * by 40%+2

What i would like to accomplish is do a search through the column with my cost $values, and if it finds a value anywhere between the numbers above then put the displayed results on the same row next column over. And I would like to do this all in one routine.

For example in column f row 10, 14, 22,48 all have cost amounts of 0-.69. then my markup would be 0-.69 * 900% and display results next column over on rows 10,14,22, and 48. And do the same for all the other cost amounts within the same routine.

I am a novice with formulas and macros on excel, but have been searching around and would my best option be a vlookup table and if statements as a macro and if so, please some guidance? Or any other suggestions?

thanks

We are trying to make 2 different formulas.

One is for a three tiered pricing formula on one price list:

Cost range of .01 - $2.75 + 80% markup = retail price

Cost range of $2.76 - $7.99 + 60% markup = retail price

Cost range of $8.00 or higher + 40% markup = retail price


The next is a two tiered pricing formula on one price list:

Any item that is $9.99 or less + 60% markup = retail price

Any item that is $9.99 or more + $6.00 = retail price

Many thanks.

*edit typo

Properties increase by 10% of the original price with each new purchase.

Current Price:

Code:

F37*(1+E37/10)

Properties are built on a required property. If the required property has not been purchased, the Current Price is:

Code:

IF(metropolis<2,VLOOKUP(metropolis,shipping_metropolis,2,FALSE)+F37*(1+E37/10),F37*(1+E37/10))

If I sell this property, the Cash Received:

Code:

E37*(G37+F37*0.9)/4

However, it's incorrect if the required property is "not owned" in the spreadsheet. I need help figuring out the formula to exclude the price of the required property (the VLOOKUP) for the Cash Received.

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?

In my provided Excel file it will be more clear what I want...

As I purchase an Item the cost increases 10%. I need the formula that will show the combined total cost of quantity purchased.

Thanks in advance
Dan

I am trying to figure out how to update cost from a vendors .xls file I want to compare my price list to the vendor price list by OEM number and Highlight any cost that have changed and show the amount of change. I have really tried and tried but I cannot figure out how to do the formula correctly. Any help would be greatly appreciated as I have to do this manually now and we have 4000 parts from this particular vendor.
Thank You
Matthew