Embedded Function?

[SkylerOkeefe]

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> [FONT=&quot]Hi all, I am trying to come up with a formula for column "B" (Middle column shown below). That column
shows my prices from my distributor. I have to put a mark-up on these prices
for my customers to shop on my website.
I am thinking if I can use something
like an embedded function/formula?. I need something like this. $100.00 to $200.00 add $30.00. $201 to $500.00 add $40.00.
$501 to $800.00 add 50.00 and so on. This file will then be converted to a csv and uploaded.
Thanks in advance for any help. Okeefe[/FONT]
[FONT=&quot]A B C[/FONT]
<table class="MsoNormalTable" style="mso-cellspacing:0in;mso-table-layout-alt:fixed;mso-yfti-tbllook:1184; mso-padding-alt:0in 0in 0in 0in" border="0" cellpadding="0" cellspacing="0" width="276"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126"> [FONT=&quot]products_image [/FONT]
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46"> [FONT=&quot]Distributor Price[/FONT]
</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103"> [FONT=&quot] products_price[/FONT]
</td> </tr> <tr style="mso-yfti-irow:1;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126"> [FONT=&quot]0208193.jpg[/FONT]
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]809.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]1001[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:2;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126">
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]809.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]1001[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:3;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126"> [FONT=&quot]0276186.jpg[/FONT]
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]809.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]1001[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:4;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126">
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]379.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]540[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:5;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126"> [FONT=&quot]0207378.jpg[/FONT]
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]379.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]540[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:6;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126">
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]379.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]540[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:7;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126">
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]209.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]295[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:8;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126"> [FONT=&quot]0206696.jpg[/FONT]
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]218.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]310[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:9;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126">
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]229.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]325[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:10;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126">
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]218.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]310[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:11;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126"> [FONT=&quot]0208381.jpg[/FONT]
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]269.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]357.99[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:12;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126">
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]274.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]364.99[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:13;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126"> [FONT=&quot]0208383.jpg[/FONT]
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]264.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]393[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:14;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126">
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]265.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]352.99[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:15;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126"> [FONT=&quot]0275842.jpg[/FONT]
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]744.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]1051[/FONT]​

</td> </tr> <tr style="mso-yfti-irow:16;mso-yfti-lastrow:yes;height:15.0pt"> <td style="width:94.5pt;padding:0in 0in 0in 0in;height:15.0pt" width="126"> [FONT=&quot]0276119.jpg[/FONT]
</td> <td style="width:34.85pt;padding:0in 0in 0in 0in;height:15.0pt" width="46">

[FONT=&quot]200.99[/FONT]​

</td> <td style="width:77.35pt;padding:0in 0in 0in 0in;height:15.0pt" width="103">

[FONT=&quot]275[/FONT]​

</td> </tr> </tbody></table>

 

[Richard Schollar]

Hi

Vlookup is what you want:

<b>Excel 2002</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Product Price</td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;;">Lower Band</td><td style="font-weight: bold;;">Upper</td><td style="font-weight: bold;;">Markup Value</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">0</td><td style="text-align: right;;">100</td><td style="text-align: right;;">20</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">101</td><td style="text-align: right;;">200</td><td style="text-align: right;;">30</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">201</td><td style="text-align: right;;">500</td><td style="text-align: right;;">40</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">501</td><td style="text-align: right;;">1000</td><td style="text-align: right;;">50</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="font-weight: bold;;">Product</td><td style="font-weight: bold;;">Supplier Cost</td><td style="font-weight: bold;;">Markup</td><td style="font-weight: bold;;">My Price</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">1</td><td style="text-align: right;;">175</td><td style="text-align: right;;">30</td><td style="text-align: right;;">205</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">2</td><td style="text-align: right;;">920</td><td style="text-align: right;;">50</td><td style="text-align: right;;">970</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">3</td><td style="text-align: right;;">400</td><td style="text-align: right;;">40</td><td style="text-align: right;;">440</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C16</th><td style="text-align:left">=VLOOKUP(<font color="Blue">B16,$A$3:$C$6,3,TRUE</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D16</th><td style="text-align:left">=SUM(<font color="Blue">B16:C16</font>)</td></tr></tbody></table></td></tr></table><br />

Formula in C16 has been copied down. It determines markup based on the lower band (A column) in the lookup table and returns the third column (col C) when a match is found. The lower bands in col A must be sorted in ascending order.