Help with formula which applies an "if" condition using table/row data.

[IGinc]

To ensure I have worded this corrects I have included some database #'s, this formula is similar to one just posted, yet more complex in regards to # of conditions needing to be met.....here are the criteria

<table width="776" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2633;width:54pt" width="72"> <col style="width:48pt" width="64" span="10"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:48pt" width="64" height="17">Cut</td> <td style="width:54pt" width="72">Carat From</td> <td style="width:48pt" width="64">Carat To</td> <td style="width:48pt" width="64">Color</td> <td style="width:48pt" width="64">IF</td> <td style="width:48pt" width="64">VVS1</td> <td style="width:48pt" width="64">VVS2</td> <td style="width:48pt" width="64">VS1</td> <td style="width:48pt" width="64">VS2</td> <td style="width:48pt" width="64">SI1</td> <td style="width:48pt" width="64">SI2</td> <td style="width:48pt" width="64">SI3</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>D</td> <td align="right">16263</td> <td align="right">13084</td> <td align="right">11679</td> <td align="right">9685</td> <td align="right">9120</td> <td align="right">7793</td> <td align="right">6426</td> <td align="right">6026</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>E</td> <td align="right">12736</td> <td align="right">11679</td> <td align="right">10961</td> <td align="right">9308</td> <td align="right">8366</td> <td align="right">7207</td> <td align="right">6026</td> <td align="right">5622</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>F</td> <td align="right">11679</td> <td align="right">10961</td> <td align="right">10233</td> <td align="right">8931</td> <td align="right">7988</td> <td align="right">6622</td> <td align="right">5622</td> <td align="right">5204</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>G</td> <td align="right">10597</td> <td align="right">9868</td> <td align="right">9308</td> <td align="right">8366</td> <td align="right">7207</td> <td align="right">6026</td> <td align="right">4989</td> <td align="right">4775</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>H</td> <td align="right">9685</td> <td align="right">8931</td> <td align="right">8178</td> <td align="right">7402</td> <td align="right">6426</td> <td align="right">5622</td> <td align="right">4775</td> <td align="right">4560</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>I</td> <td align="right">8178</td> <td align="right">7597</td> <td align="right">7012</td> <td align="right">6229</td> <td align="right">5622</td> <td align="right">4989</td> <td align="right">4560</td> <td align="right">4337</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>D</td> <td align="right">18168</td> <td align="right">14512</td> <td align="right">12808</td> <td align="right">11542</td> <td align="right">10732</td> <td align="right">9391</td> <td align="right">8533</td> <td align="right">7291</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>E</td> <td align="right">14048</td> <td align="right">12808</td> <td align="right">11704</td> <td align="right">11057</td> <td align="right">10066</td> <td align="right">9047</td> <td align="right">8178</td> <td align="right">6923</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>F</td> <td align="right">12808</td> <td align="right">11866</td> <td align="right">11057</td> <td align="right">10399</td> <td align="right">9563</td> <td align="right">8533</td> <td align="right">7645</td> <td align="right">6739</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>G</td> <td align="right">11704</td> <td align="right">10732</td> <td align="right">10066</td> <td align="right">9391</td> <td align="right">8703</td> <td align="right">7823</td> <td align="right">7107</td> <td align="right">6555</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>H</td> <td align="right">10732</td> <td align="right">9899</td> <td align="right">9219</td> <td align="right">8533</td> <td align="right">8000</td> <td align="right">7291</td> <td align="right">6739</td> <td align="right">6188</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>I</td> <td align="right">9219</td> <td align="right">8703</td> <td align="right">8356</td> <td align="right">7823</td> <td align="right">7291</td> <td align="right">6739</td> <td align="right">6004</td> <td align="right">5623</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>D</td> <td align="right">21360</td> <td align="right">18306</td> <td align="right">16230</td> <td align="right">13354</td> <td align="right">12279</td> <td align="right">11659</td> <td align="right">10256</td> <td align="right">8298</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>E</td> <td align="right">18159</td> <td align="right">17271</td> <td align="right">15026</td> <td align="right">12434</td> <td align="right">11814</td> <td align="right">11039</td> <td align="right">9940</td> <td align="right">7960</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>F</td> <td align="right">17271</td> <td align="right">16528</td> <td align="right">14118</td> <td align="right">11969</td> <td align="right">11349</td> <td align="right">10571</td> <td align="right">9616</td> <td align="right">7788</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>G</td> <td align="right">15026</td> <td align="right">13965</td> <td align="right">12279</td> <td align="right">11194</td> <td align="right">10571</td> <td align="right">9940</td> <td align="right">8966</td> <td align="right">7443</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>H</td> <td align="right">12589</td> <td align="right">11969</td> <td align="right">11349</td> <td align="right">10728</td> <td align="right">10099</td> <td align="right">9293</td> <td align="right">8632</td> <td align="right">7098</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>I</td> <td align="right">10885</td> <td align="right">10413</td> <td align="right">9778</td> <td align="right">9454</td> <td align="right">8799</td> <td align="right">8465</td> <td align="right">7788</td> <td align="right">6565</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>J</td> <td align="right">9293</td> <td align="right">8966</td> <td align="right">8632</td> <td align="right">8298</td> <td align="right">7788</td> <td align="right">7616</td> <td align="right">7098</td> <td align="right">6028</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1</td> <td align="right">1.49</td> <td>D</td> <td align="right">38634</td> <td align="right">29561</td> <td align="right">25768</td> <td align="right">20358</td> <td align="right">16501</td> <td align="right">14347</td> <td align="right">12315</td> <td align="right">10062</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1</td> <td align="right">1.49</td> <td>E</td> <td align="right">27747</td> <td align="right">26379</td> <td align="right">22848</td> <td align="right">18929</td> <td align="right">15679</td> <td align="right">13507</td> <td align="right">11799</td> <td align="right">9537</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1</td> <td align="right">1.49</td> <td>F</td> <td align="right">25462</td> <td align="right">23465</td> <td align="right">21143</td> <td align="right">17481</td> <td align="right">15015</td> <td align="right">12996</td> <td align="right">11282</td> <td align="right">9182</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1</td> <td align="right">1.49</td> <td>G</td> <td align="right">18929</td> <td align="right">18289</td> <td align="right">17642</td> <td align="right">15679</td> <td align="right">14179</td> <td align="right">12315</td> <td align="right">10937</td> <td align="right">8828</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1</td> <td align="right">1.49</td> <td>H</td> <td align="right">16174</td> <td align="right">15513</td> <td align="right">14683</td> <td align="right">13507</td> <td align="right">12486</td> <td align="right">11799</td> <td align="right">10587</td> <td align="right">8650</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1</td> <td align="right">1.49</td> <td>I</td> <td align="right">14179</td> <td align="right">13843</td> <td align="right">12996</td> <td align="right">11799</td> <td align="right">11282</td> <td align="right">10762</td> <td align="right">9712</td> <td align="right">8116</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>D</td> <td align="right">40932</td> <td align="right">33933</td> <td align="right">31574</td> <td align="right">24945</td> <td align="right">20632</td> <td align="right">17115</td> <td align="right">14427</td> <td align="right">11486</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>E</td> <td align="right">33242</td> <td align="right">31993</td> <td align="right">27361</td> <td align="right">23659</td> <td align="right">19758</td> <td align="right">16521</td> <td align="right">13818</td> <td align="right">11008</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>F</td> <td align="right">29334</td> <td align="right">27079</td> <td align="right">25943</td> <td align="right">21933</td> <td align="right">19029</td> <td align="right">15780</td> <td align="right">13049</td> <td align="right">10689</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>G</td> <td align="right">21500</td> <td align="right">21066</td> <td align="right">20195</td> <td align="right">18588</td> <td align="right">16967</td> <td align="right">14579</td> <td align="right">12272</td> <td align="right">10045</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>H</td> <td align="right">17853</td> <td align="right">17412</td> <td align="right">16967</td> <td align="right">15631</td> <td align="right">14730</td> <td align="right">13665</td> <td align="right">11800</td> <td align="right">9396</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>I</td> <td align="right">16076</td> <td align="right">15928</td> <td align="right">15481</td> <td align="right">13972</td> <td align="right">13049</td> <td align="right">12272</td> <td align="right">10689</td> <td align="right">8742</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>J</td> <td align="right">13665</td> <td align="right">13511</td> <td align="right">13049</td> <td align="right">11957</td> <td align="right">11008</td> <td align="right">10689</td> <td align="right">9560</td> <td align="right">7913</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2</td> <td align="right">2.49</td> <td>D</td> <td align="right">54812</td> <td align="right">45097</td> <td align="right">41029</td> <td align="right">34227</td> <td align="right">25768</td> <td align="right">20304</td> <td align="right">17041</td> <td align="right">12311</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2</td> <td align="right">2.49</td> <td>E</td> <td align="right">43828</td> <td align="right">41284</td> <td align="right">35775</td> <td align="right">30989</td> <td align="right">24845</td> <td align="right">19899</td> <td align="right">16629</td> <td align="right">12028</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2</td> <td align="right">2.49</td> <td>F</td> <td align="right">38985</td> <td align="right">35517</td> <td align="right">32287</td> <td align="right">27733</td> <td align="right">23917</td> <td align="right">18950</td> <td align="right">15666</td> <td align="right">11602</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2</td> <td align="right">2.49</td> <td>G</td> <td align="right">29037</td> <td align="right">26949</td> <td align="right">24845</td> <td align="right">22986</td> <td align="right">21246</td> <td align="right">17861</td> <td align="right">15112</td> <td align="right">11026</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2</td> <td align="right">2.49</td> <td>H</td> <td align="right">23253</td> <td align="right">21917</td> <td align="right">20573</td> <td align="right">19628</td> <td align="right">18407</td> <td align="right">16218</td> <td align="right">14277</td> <td align="right">10299</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2</td> <td align="right">2.49</td> <td>I</td> <td align="right">19357</td> <td align="right">18814</td> <td align="right">17861</td> <td align="right">16629</td> <td align="right">15527</td> <td align="right">14277</td> <td align="right">13157</td> <td align="right">9562</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>D</td> <td align="right">61491</td> <td align="right">50408</td> <td align="right">45781</td> <td align="right">38092</td> <td align="right">28551</td> <td align="right">22429</td> <td align="right">18786</td> <td align="right">13496</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>E</td> <td align="right">48962</td> <td align="right">46071</td> <td align="right">39836</td> <td align="right">34448</td> <td align="right">27512</td> <td align="right">21978</td> <td align="right">18326</td> <td align="right">13180</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>F</td> <td align="right">43463</td> <td align="right">39545</td> <td align="right">35908</td> <td align="right">30771</td> <td align="right">26470</td> <td align="right">20920</td> <td align="right">17247</td> <td align="right">12703</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>G</td> <td align="right">32246</td> <td align="right">29885</td> <td align="right">27512</td> <td align="right">25426</td> <td align="right">23479</td> <td align="right">19704</td> <td align="right">16627</td> <td align="right">12066</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>H</td> <td align="right">25724</td> <td align="right">24229</td> <td align="right">22729</td> <td align="right">21676</td> <td align="right">20314</td> <td align="right">17864</td> <td align="right">15693</td> <td align="right">11263</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>I</td> <td align="right">21374</td> <td align="right">20769</td> <td align="right">19704</td> <td align="right">18326</td> <td align="right">17092</td> <td align="right">15693</td> <td align="right">14441</td> <td align="right">10454</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3</td> <td align="right">3.49</td> <td>D</td> <td align="right">92995</td> <td align="right">73006</td> <td align="right">65266</td> <td align="right">51302</td> <td align="right">41290</td> <td align="right">28269</td> <td align="right">21559</td> <td align="right">14852</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3</td> <td align="right">3.49</td> <td>E</td> <td align="right">71573</td> <td align="right">65409</td> <td align="right">55490</td> <td align="right">45070</td> <td align="right">38231</td> <td align="right">26788</td> <td align="right">20505</td> <td align="right">14229</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3</td> <td align="right">3.49</td> <td>F</td> <td align="right">62254</td> <td align="right">57651</td> <td align="right">49130</td> <td align="right">41290</td> <td align="right">35749</td> <td align="right">25302</td> <td align="right">19749</td> <td align="right">13603</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3</td> <td align="right">3.49</td> <td>G</td> <td align="right">50579</td> <td align="right">45796</td> <td align="right">41581</td> <td align="right">37355</td> <td align="right">31800</td> <td align="right">23061</td> <td align="right">18843</td> <td align="right">12975</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3</td> <td align="right">3.49</td> <td>H</td> <td align="right">39107</td> <td align="right">37647</td> <td align="right">35166</td> <td align="right">31068</td> <td align="right">27086</td> <td align="right">20203</td> <td align="right">18083</td> <td align="right">12344</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3</td> <td align="right">3.49</td> <td>I</td> <td align="right">28712</td> <td align="right">27973</td> <td align="right">27086</td> <td align="right">24556</td> <td align="right">21258</td> <td align="right">17931</td> <td align="right">15937</td> <td align="right">11392</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>D</td> <td align="right">101762</td> <td align="right">79771</td> <td align="right">71250</td> <td align="right">55886</td> <td align="right">44896</td> <td align="right">30584</td> <td align="right">23268</td> <td align="right">15966</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>E</td> <td align="right">78193</td> <td align="right">71408</td> <td align="right">60486</td> <td align="right">49047</td> <td align="right">41532</td> <td align="right">28965</td> <td align="right">22117</td> <td align="right">15292</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>F</td> <td align="right">67928</td> <td align="right">62865</td> <td align="right">53505</td> <td align="right">44896</td> <td align="right">38803</td> <td align="right">27346</td> <td align="right">21292</td> <td align="right">14615</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>G</td> <td align="right">55093</td> <td align="right">49844</td> <td align="right">45215</td> <td align="right">40570</td> <td align="right">34458</td> <td align="right">24905</td> <td align="right">20300</td> <td align="right">13934</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>H</td> <td align="right">42494</td> <td align="right">40892</td> <td align="right">38161</td> <td align="right">33652</td> <td align="right">29289</td> <td align="right">21788</td> <td align="right">19471</td> <td align="right">13250</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>I</td> <td align="right">31068</td> <td align="right">30261</td> <td align="right">29289</td> <td align="right">26535</td> <td align="right">22939</td> <td align="right">19305</td> <td align="right">17138</td> <td align="right">12216</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">4</td> <td align="right">4.99</td> <td>D</td> <td align="right">108471</td> <td align="right">87001</td> <td align="right">79859</td> <td align="right">65033</td> <td align="right">51721</td> <td align="right">32511</td> <td align="right">24038</td> <td align="right">15966</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">4</td> <td align="right">4.99</td> <td>E</td> <td align="right">86759</td> <td align="right">79495</td> <td align="right">69172</td> <td align="right">58446</td> <td align="right">49025</td> <td align="right">31394</td> <td align="right">23412</td> <td align="right">15292</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">4</td> <td align="right">4.99</td> <td>F</td> <td align="right">78646</td> <td align="right">69050</td> <td align="right">62594</td> <td align="right">54290</td> <td align="right">45102</td> <td align="right">29901</td> <td align="right">22912</td> <td align="right">14615</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">4</td> <td align="right">4.99</td> <td>G</td> <td align="right">60156</td> <td align="right">54290</td> <td align="right">51108</td> <td align="right">48289</td> <td align="right">39935</td> <td align="right">26786</td> <td align="right">21279</td> <td align="right">13934</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">4</td> <td align="right">4.99</td> <td>H</td> <td align="right">46451</td> <td align="right">44242</td> <td align="right">41413</td> <td align="right">38701</td> <td align="right">32884</td> <td align="right">24163</td> <td align="right">19764</td> <td align="right">13250</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">4</td> <td align="right">4.99</td> <td>I</td> <td align="right">34248</td> <td align="right">32635</td> <td align="right">31394</td> <td align="right">29155</td> <td align="right">25788</td> <td align="right">20522</td> <td align="right">17729</td> <td align="right">12216</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">5</td> <td align="right">5.99</td> <td>D</td> <td align="right">151898</td> <td align="right">106282</td> <td align="right">104730</td> <td align="right">88709</td> <td align="right">68208</td> <td align="right">42576</td> <td align="right">29570</td> <td align="right">15966</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">5</td> <td align="right">5.99</td> <td>E</td> <td align="right">114849</td> <td align="right">103752</td> <td align="right">91771</td> <td align="right">79882</td> <td align="right">64511</td> <td align="right">39585</td> <td align="right">28688</td> <td align="right">15292</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">5</td> <td align="right">5.99</td> <td>F</td> <td align="right">101309</td> <td align="right">91526</td> <td align="right">84178</td> <td align="right">74971</td> <td align="right">55861</td> <td align="right">36341</td> <td align="right">27554</td> <td align="right">14615</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">5</td> <td align="right">5.99</td> <td>G</td> <td align="right">76813</td> <td align="right">69439</td> <td align="right">64141</td> <td align="right">59202</td> <td align="right">49663</td> <td align="right">33714</td> <td align="right">26165</td> <td align="right">13934</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">5</td> <td align="right">5.99</td> <td>H</td> <td align="right">62043</td> <td align="right">56480</td> <td align="right">52144</td> <td align="right">47178</td> <td align="right">39834</td> <td align="right">29570</td> <td align="right">23761</td> <td align="right">13250</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Round</td> <td align="right">5</td> <td align="right">5.99</td> <td>I</td> <td align="right">45438</td> <td align="right">42701</td> <td align="right">41330</td> <td align="right">37216</td> <td align="right">33714</td> <td align="right">25280</td> <td align="right">20843</td> <td align="right">12216</td> </tr> </tbody></table>

<table width="768" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" width="64" span="12"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:48pt" width="64" height="17">Cut</td> <td style="width:48pt" width="64">Carat From</td> <td style="width:48pt" width="64">Carat To</td> <td style="width:48pt" width="64">Color</td> <td style="width:48pt" width="64">IF</td> <td style="width:48pt" width="64">VVS1</td> <td style="width:48pt" width="64">VVS2</td> <td style="width:48pt" width="64">VS1</td> <td style="width:48pt" width="64">VS2</td> <td style="width:48pt" width="64">SI1</td> <td style="width:48pt" width="64">SI2</td> <td style="width:48pt" width="64">SI3</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>D</td> <td align="right">9076</td> <td align="right">7912</td> <td align="right">7312</td> <td align="right">6711</td> <td align="right">6260</td> <td align="right">5319</td> <td align="right">4659</td> <td align="right">4320</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>E</td> <td align="right">8062</td> <td align="right">7312</td> <td align="right">6862</td> <td align="right">6104</td> <td align="right">5637</td> <td align="right">4824</td> <td align="right">3969</td> <td align="right">3969</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>F</td> <td align="right">7312</td> <td align="right">6862</td> <td align="right">6260</td> <td align="right">5793</td> <td align="right">5319</td> <td align="right">4659</td> <td align="right">3793</td> <td align="right">3793</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>G</td> <td align="right">6862</td> <td align="right">6260</td> <td align="right">5793</td> <td align="right">5319</td> <td align="right">4824</td> <td align="right">4320</td> <td align="right">3617</td> <td align="right">3617</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>H</td> <td align="right">6260</td> <td align="right">5793</td> <td align="right">5484</td> <td align="right">4989</td> <td align="right">4659</td> <td align="right">3793</td> <td align="right">3441</td> <td align="right">3441</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.5</td> <td align="right">0.69</td> <td>I</td> <td align="right">5484</td> <td align="right">4989</td> <td align="right">4824</td> <td align="right">4495</td> <td align="right">4144</td> <td align="right">3793</td> <td align="right">3441</td> <td align="right">3253</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>D</td> <td align="right">11037</td> <td align="right">8983</td> <td align="right">8588</td> <td align="right">8184</td> <td align="right">7776</td> <td align="right">7091</td> <td align="right">6247</td> <td align="right">5818</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>E</td> <td align="right">9115</td> <td align="right">8588</td> <td align="right">8320</td> <td align="right">7776</td> <td align="right">7232</td> <td align="right">6388</td> <td align="right">5673</td> <td align="right">5381</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>F</td> <td align="right">8720</td> <td align="right">8320</td> <td align="right">8048</td> <td align="right">7504</td> <td align="right">6810</td> <td align="right">6106</td> <td align="right">5381</td> <td align="right">5090</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>G</td> <td align="right">8320</td> <td align="right">7912</td> <td align="right">7504</td> <td align="right">6950</td> <td align="right">6388</td> <td align="right">5527</td> <td align="right">5090</td> <td align="right">4944</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>H</td> <td align="right">7640</td> <td align="right">7091</td> <td align="right">6950</td> <td align="right">6528</td> <td align="right">5818</td> <td align="right">5090</td> <td align="right">4798</td> <td align="right">4651</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.7</td> <td align="right">0.89</td> <td>I</td> <td align="right">6669</td> <td align="right">6247</td> <td align="right">6106</td> <td align="right">5673</td> <td align="right">4944</td> <td align="right">4500</td> <td align="right">4197</td> <td align="right">4046</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>D</td> <td align="right">11954</td> <td align="right">9863</td> <td align="right">9623</td> <td align="right">9142</td> <td align="right">8648</td> <td align="right">8276</td> <td align="right">7386</td> <td align="right">6205</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>E</td> <td align="right">9863</td> <td align="right">9623</td> <td align="right">9142</td> <td align="right">8772</td> <td align="right">8400</td> <td align="right">7898</td> <td align="right">6998</td> <td align="right">5935</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>F</td> <td align="right">9623</td> <td align="right">9142</td> <td align="right">8648</td> <td align="right">8400</td> <td align="right">8025</td> <td align="right">7642</td> <td align="right">6866</td> <td align="right">5798</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>G</td> <td align="right">9142</td> <td align="right">8648</td> <td align="right">8400</td> <td align="right">8153</td> <td align="right">7642</td> <td align="right">7130</td> <td align="right">6469</td> <td align="right">5661</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>H</td> <td align="right">8153</td> <td align="right">7642</td> <td align="right">7386</td> <td align="right">7130</td> <td align="right">6734</td> <td align="right">6469</td> <td align="right">5798</td> <td align="right">5388</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">0.9</td> <td align="right">0.99</td> <td>I</td> <td align="right">7386</td> <td align="right">6998</td> <td align="right">6866</td> <td align="right">6601</td> <td align="right">6205</td> <td align="right">6072</td> <td align="right">5388</td> <td align="right">4834</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1</td> <td align="right">1.49</td> <td>D</td> <td align="right">17752</td> <td align="right">12644</td> <td align="right">11539</td> <td align="right">11046</td> <td align="right">10297</td> <td align="right">9292</td> <td align="right">8021</td> <td align="right">6841</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1</td> <td align="right">1.49</td> <td>E</td> <td align="right">12644</td> <td align="right">11539</td> <td align="right">11169</td> <td align="right">10797</td> <td align="right">10047</td> <td align="right">8912</td> <td align="right">7764</td> <td align="right">6704</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1</td> <td align="right">1.49</td> <td>F</td> <td align="right">11539</td> <td align="right">11169</td> <td align="right">10923</td> <td align="right">10422</td> <td align="right">9546</td> <td align="right">8658</td> <td align="right">7635</td> <td align="right">6567</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1</td> <td align="right">1.49</td> <td>G</td> <td align="right">11169</td> <td align="right">10923</td> <td align="right">10547</td> <td align="right">9922</td> <td align="right">9166</td> <td align="right">8150</td> <td align="right">7239</td> <td align="right">6294</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1</td> <td align="right">1.49</td> <td>H</td> <td align="right">9546</td> <td align="right">9039</td> <td align="right">8658</td> <td align="right">8278</td> <td align="right">7635</td> <td align="right">7107</td> <td align="right">6431</td> <td align="right">6017</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1</td> <td align="right">1.49</td> <td>I</td> <td align="right">8404</td> <td align="right">8150</td> <td align="right">7892</td> <td align="right">7635</td> <td align="right">7107</td> <td align="right">6567</td> <td align="right">5876</td> <td align="right">5594</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>D</td> <td align="right">20909</td> <td align="right">15170</td> <td align="right">14089</td> <td align="right">13723</td> <td align="right">12988</td> <td align="right">12245</td> <td align="right">10352</td> <td align="right">8404</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>E</td> <td align="right">15170</td> <td align="right">14089</td> <td align="right">13723</td> <td align="right">13357</td> <td align="right">12741</td> <td align="right">11995</td> <td align="right">10223</td> <td align="right">8272</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>F</td> <td align="right">14089</td> <td align="right">13723</td> <td align="right">13357</td> <td align="right">12741</td> <td align="right">12245</td> <td align="right">11620</td> <td align="right">9838</td> <td align="right">8008</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>G</td> <td align="right">13723</td> <td align="right">13357</td> <td align="right">12741</td> <td align="right">12371</td> <td align="right">11620</td> <td align="right">10734</td> <td align="right">9320</td> <td align="right">7744</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>H</td> <td align="right">11494</td> <td align="right">11242</td> <td align="right">10861</td> <td align="right">10480</td> <td align="right">9966</td> <td align="right">9320</td> <td align="right">8272</td> <td align="right">7075</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">1.5</td> <td align="right">1.99</td> <td>I</td> <td align="right">10095</td> <td align="right">9838</td> <td align="right">9709</td> <td align="right">9320</td> <td align="right">8929</td> <td align="right">8536</td> <td align="right">7343</td> <td align="right">6536</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2</td> <td align="right">2.49</td> <td>D</td> <td align="right">29134</td> <td align="right">21980</td> <td align="right">20478</td> <td align="right">18858</td> <td align="right">17771</td> <td align="right">14806</td> <td align="right">11321</td> <td align="right">8857</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2</td> <td align="right">2.49</td> <td>E</td> <td align="right">21980</td> <td align="right">20478</td> <td align="right">18858</td> <td align="right">17771</td> <td align="right">16240</td> <td align="right">14249</td> <td align="right">11091</td> <td align="right">8616</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2</td> <td align="right">2.49</td> <td>F</td> <td align="right">20478</td> <td align="right">18858</td> <td align="right">17771</td> <td align="right">16240</td> <td align="right">15137</td> <td align="right">13691</td> <td align="right">10860</td> <td align="right">8374</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2</td> <td align="right">2.49</td> <td>G</td> <td align="right">18424</td> <td align="right">17336</td> <td align="right">16240</td> <td align="right">15137</td> <td align="right">14583</td> <td align="right">12569</td> <td align="right">10512</td> <td align="right">8009</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2</td> <td align="right">2.49</td> <td>H</td> <td align="right">15248</td> <td align="right">14137</td> <td align="right">13018</td> <td align="right">12456</td> <td align="right">11891</td> <td align="right">10860</td> <td align="right">9215</td> <td align="right">7272</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2</td> <td align="right">2.49</td> <td>I</td> <td align="right">12456</td> <td align="right">11891</td> <td align="right">11321</td> <td align="right">10744</td> <td align="right">10162</td> <td align="right">9691</td> <td align="right">8495</td> <td align="right">6900</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>D</td> <td align="right">32038</td> <td align="right">24064</td> <td align="right">22406</td> <td align="right">20617</td> <td align="right">19415</td> <td align="right">16129</td> <td align="right">12276</td> <td align="right">9598</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>E</td> <td align="right">24064</td> <td align="right">22406</td> <td align="right">20617</td> <td align="right">19415</td> <td align="right">17718</td> <td align="right">15513</td> <td align="right">12024</td> <td align="right">9339</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>F</td> <td align="right">22406</td> <td align="right">20617</td> <td align="right">19415</td> <td align="right">17718</td> <td align="right">16496</td> <td align="right">14895</td> <td align="right">11770</td> <td align="right">9077</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>G</td> <td align="right">20138</td> <td align="right">18932</td> <td align="right">17718</td> <td align="right">16496</td> <td align="right">15882</td> <td align="right">13654</td> <td align="right">11390</td> <td align="right">8682</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>H</td> <td align="right">16619</td> <td align="right">15390</td> <td align="right">14152</td> <td align="right">13529</td> <td align="right">12904</td> <td align="right">11770</td> <td align="right">9986</td> <td align="right">7882</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">2.5</td> <td align="right">2.99</td> <td>I</td> <td align="right">13529</td> <td align="right">12904</td> <td align="right">12276</td> <td align="right">11643</td> <td align="right">11009</td> <td align="right">10497</td> <td align="right">9208</td> <td align="right">7476</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3</td> <td align="right">3.49</td> <td>D</td> <td align="right">49949</td> <td align="right">40991</td> <td align="right">36380</td> <td align="right">30397</td> <td align="right">26408</td> <td align="right">19588</td> <td align="right">14022</td> <td align="right">11591</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3</td> <td align="right">3.49</td> <td>E</td> <td align="right">39643</td> <td align="right">36717</td> <td align="right">34013</td> <td align="right">28807</td> <td align="right">24916</td> <td align="right">19005</td> <td align="right">13418</td> <td align="right">11100</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3</td> <td align="right">3.49</td> <td>F</td> <td align="right">34916</td> <td align="right">32997</td> <td align="right">30397</td> <td align="right">26752</td> <td align="right">23187</td> <td align="right">17833</td> <td align="right">12933</td> <td align="right">10729</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3</td> <td align="right">3.49</td> <td>G</td> <td align="right">31191</td> <td align="right">29262</td> <td align="right">27780</td> <td align="right">23648</td> <td align="right">20986</td> <td align="right">16059</td> <td align="right">12690</td> <td align="right">10235</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3</td> <td align="right">3.49</td> <td>H</td> <td align="right">26293</td> <td align="right">25146</td> <td align="right">23072</td> <td align="right">20170</td> <td align="right">17598</td> <td align="right">13781</td> <td align="right">11836</td> <td align="right">9486</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3</td> <td align="right">3.49</td> <td>I</td> <td align="right">20637</td> <td align="right">19588</td> <td align="right">18654</td> <td align="right">17244</td> <td align="right">14504</td> <td align="right">12324</td> <td align="right">10482</td> <td align="right">8606</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>D</td> <td align="right">52517</td> <td align="right">43031</td> <td align="right">38144</td> <td align="right">31799</td> <td align="right">27593</td> <td align="right">20414</td> <td align="right">14576</td> <td align="right">12029</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>E</td> <td align="right">41603</td> <td align="right">38502</td> <td align="right">35633</td> <td align="right">30119</td> <td align="right">26024</td> <td align="right">19800</td> <td align="right">13944</td> <td align="right">11513</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>F</td> <td align="right">36591</td> <td align="right">34556</td> <td align="right">31799</td> <td align="right">27954</td> <td align="right">24205</td> <td align="right">18564</td> <td align="right">13436</td> <td align="right">11126</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>G</td> <td align="right">32639</td> <td align="right">30599</td> <td align="right">29036</td> <td align="right">24691</td> <td align="right">21887</td> <td align="right">16704</td> <td align="right">13181</td> <td align="right">10606</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>H</td> <td align="right">27472</td> <td align="right">26266</td> <td align="right">24084</td> <td align="right">21029</td> <td align="right">18317</td> <td align="right">14324</td> <td align="right">12286</td> <td align="right">9824</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">3.5</td> <td align="right">3.99</td> <td>I</td> <td align="right">21520</td> <td align="right">20414</td> <td align="right">19429</td> <td align="right">17946</td> <td align="right">15080</td> <td align="right">12798</td> <td align="right">10866</td> <td align="right">8903</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">4</td> <td align="right">4.99</td> <td>D</td> <td align="right">67256</td> <td align="right">54863</td> <td align="right">49665</td> <td align="right">44231</td> <td align="right">38774</td> <td align="right">24321</td> <td align="right">17329</td> <td align="right">13049</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">4</td> <td align="right">4.99</td> <td>E</td> <td align="right">53396</td> <td align="right">49665</td> <td align="right">46610</td> <td align="right">40823</td> <td align="right">36150</td> <td align="right">23512</td> <td align="right">16739</td> <td align="right">12447</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">4</td> <td align="right">4.99</td> <td>F</td> <td align="right">48533</td> <td align="right">46610</td> <td align="right">43210</td> <td align="right">37634</td> <td align="right">32373</td> <td align="right">22124</td> <td align="right">16266</td> <td align="right">11841</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">4</td> <td align="right">4.99</td> <td>G</td> <td align="right">41506</td> <td align="right">37862</td> <td align="right">34892</td> <td align="right">33405</td> <td align="right">28355</td> <td align="right">20613</td> <td align="right">15910</td> <td align="right">11232</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">4</td> <td align="right">4.99</td> <td>H</td> <td align="right">34321</td> <td align="right">32488</td> <td align="right">29964</td> <td align="right">28010</td> <td align="right">23974</td> <td align="right">18272</td> <td align="right">14245</td> <td align="right">10374</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">4</td> <td align="right">4.99</td> <td>I</td> <td align="right">25821</td> <td align="right">24783</td> <td align="right">23512</td> <td align="right">22008</td> <td align="right">20730</td> <td align="right">16147</td> <td align="right">12688</td> <td align="right">9260</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">5</td> <td align="right">5.99</td> <td>D</td> <td align="right">94265</td> <td align="right">72589</td> <td align="right">66934</td> <td align="right">60174</td> <td align="right">49884</td> <td align="right">31036</td> <td align="right">20762</td> <td align="right">14073</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">5</td> <td align="right">5.99</td> <td>E</td> <td align="right">71394</td> <td align="right">66717</td> <td align="right">61701</td> <td align="right">55800</td> <td align="right">46700</td> <td align="right">30037</td> <td align="right">20199</td> <td align="right">13383</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">5</td> <td align="right">5.99</td> <td>F</td> <td align="right">61156</td> <td align="right">57331</td> <td align="right">54050</td> <td align="right">49665</td> <td align="right">40760</td> <td align="right">27476</td> <td align="right">19187</td> <td align="right">12921</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">5</td> <td align="right">5.99</td> <td>G</td> <td align="right">50542</td> <td align="right">46371</td> <td align="right">43623</td> <td align="right">39769</td> <td align="right">34030</td> <td align="right">24795</td> <td align="right">18400</td> <td align="right">12459</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">5</td> <td align="right">5.99</td> <td>H</td> <td align="right">44173</td> <td align="right">40870</td> <td align="right">37014</td> <td align="right">34030</td> <td align="right">29591</td> <td align="right">21771</td> <td align="right">16133</td> <td align="right">11415</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Fancy</td> <td align="right">5</td> <td align="right">5.99</td> <td>I</td> <td align="right">30814</td> <td align="right">28701</td> <td align="right">27029</td> <td align="right">24795</td> <td align="right">22893</td> <td align="right">17495</td> <td align="right">13844</td> <td align="right">10247</td> </tr> </tbody></table>

Fancy Includes in spreadsheet numerous values. Constants are Round, Fancy, Numerical Range, and letters, Numbers in each column are variables that change on a basis.

Formula:

ex:

If criteria is met in cell "a" (round or fancy), and is between the range in cell "b" and "c", matches the letter in d, and e, then multiply "F" to achieve correct result in column "G".

eg= Formula would take a cell with row data that has .5, round, D, IF, and take 1/2 to fill in column G

Data is not in these columns, kindly explain formula so I may manipulate it for my spreadsheet.

Thanks

- Mike

 

[IGinc]

bump.... have I provided all needed info?

 

[IGinc]

I cant be the only one who has to work on Sunday, someone please help....

 

[ukmikeb]

To ensure I have worded this corrects I have included some database #'s, this formula is similar to one just posted, yet more complex in regards to # of conditions needing to be met.....here are the criteria
Formula:

ex:

If criteria is met in cell "a" (round or fancy), and is between the range in cell "b" and "c", matches the letter in d, and e, then multiply "F" to achieve correct result in column "G".

eg= Formula would take a cell with row data that has .5, round, D, IF, and take 1/2 to fill in column G

Data is not in these columns, kindly explain formula so I may manipulate it for my spreadsheet.

Mike

May I suggest that you post subsets of your data (0.5 through 0.9 Round and Fancy) using one of the Utilities in my signature.

Then show the result the Formula is expected to produce as it is a mystery as to what you're trying to achieve from your first paragraph as quoted above.

 

[borgem]

I'm with ukmike, I'm not entirely sure what you are after.

I have put together a macro that would help you apply an autofilter if you are up for it. I copied and pasted your data into excel with the headers beginning @ A4. The top of my sheet looks like this.

<table border="0" cellpadding="0" cellspacing="0" width="320"> <col style="width:48pt" span="5" width="64"> <tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:48pt" height="20" width="64">
</td> <td class="xl65" style="width:48pt" width="64"> A</td> <td class="xl65" style="width:48pt" width="64">B</td> <td class="xl65" style="width:48pt" width="64">C</td> <td class="xl65" style="width:48pt" width="64">D</td> </tr> <tr style="height:15.75pt" height="21"> <td style="height:15.75pt" align="right" height="21">1</td> <td class="xl66" style="width:48pt" width="64"> Cut</td> <td class="xl66" style="width:48pt" width="64">Carat</td> <td class="xl66" style="width:48pt" width="64">Color</td> <td class="xl66" style="width:48pt" width="64">IF</td> </tr> <tr style="height:15.75pt" height="21"> <td style="height:15.75pt" align="right" height="21">2</td> <td class="xl65"> Round</td> <td class="xl65">0.5</td> <td class="xl65">D</td> <td class="xl65">16263</td> </tr> </tbody> </table>

Sub FilterGems()
    
    With Sheet1

            .AutoFilterMode = False
            
            .Range("A4:L4").AutoFilter
            .Range("A4:L4").AutoFilter Field:=1, Criteria1:=.Range("A2")
            .Range("A4:L4").AutoFilter Field:=2, Criteria1:="<=" & .Range("B2")
            .Range("A4:L4").AutoFilter Field:=3, Criteria1:=">=" & .Range("B2")
            .Range("A4:L4").AutoFilter Field:=4, Criteria1:=.Range("C2")

    End With

End Sub

When you run the macro, it narrows down your data to fit whatever criteria you put into A2 through C2. You can add to the macro for more filtering. It doesn't have any formula built in since I wasn't sure how to apply it, but it would filter down your data to meet the criteria entered. So maybe that will put you in the right direction?

 

[IGinc]

borgem: I have no experience with Macro, tho I can see how my data can look confusing, If I labeled the table data it as you did, would this make it easier for you guys to create a solution for me, as that is how it seems to me, please correct me if I misunderstood you?

Your sample is exactly what I am after, though it does not include all of the possible "lookups" the table creates. I am doing my best to use the correct terminology.

I will create a table as you did, and hopefully you or someone else on the board can help once I have clearly explained myself. Thank you for the staring off point.

Mike

 

[borgem]

I think the most useful feedback for us would be an example of an actual calculation, including all of the steps. Without those specifics, there isn't much to go on.

 

[IGinc]

Thanks, I will post that shortly.

 

[IGinc]

Help with formula which applies an "if" condition using table/row data.
<hr style="color:#FFFFFF; background-color:#FFFFFF" size="1"> The goal is to acheive an Estimated Retail Price, which is determined by one of combinations: Round, in Range .50-.69 Color

Will post calculation in next post.
<table style="width: 828px; height: 134px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2633;width:54pt" width="72"> <col style="width:48pt" width="64" span="10"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:48pt" width="64" height="17">
D
Cut

1.Round


</td> <td style="width:54pt" width="72">
F
Carat
From
.50

</td> <td style="width:48pt" width="64">
F
Carat To

.69

</td> <td style="width:48pt" width="64">H
Color

D
</td> <td style="width:48pt" width="64">

S
Clarity1

IF


</td> <td style="width:48pt" width="64">

S
Clarity2

VVS1


</td> <td style="width:48pt" width="64">

S
Clarity3

VVS2


</td> <td style="width:48pt" width="64">

S
Clarity4

VS1


</td> <td style="width:48pt" width="64">

S
Clarity5

VS2


</td> <td style="width:48pt" width="64">

S
Clarity6

SI1


</td> <td style="width:48pt" width="64">

S
Clar 7 8

SI2


</td> <td style="width:48pt" width="64">

S


SI3


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

 

[IGinc]

Each line is a subset a- the calculation is 1, the Stone Type, Round or Fancy, 2, the stone Range .50-.69, etc, 3. Color (all in same row = D, E, F, G, H, I, or Natural) 4, Clarity. As shown. Depending on which subset the data falls in,

for example a Round, .55, D, IF is (price) is multiplied by 16263. Equating to in the same sense a second example would be a .55 D IF would be multiplied by 16123. Shape, Color, Clarity are all in the same row. I do also have two separate tabs that have the data, if that is an easier approach.

Appreciate those who are helping, I am doing my best to the data in a format that is most useful for you.

Regards,
Mike