Calculating Bonus

[candybcool]

I need a formula to calculate bonuses base on an array.

Example if
$25 - $49 bonus would be $25
$50 - $99 bonus would be $50

then I need a formula to calculate total sales

Total sales is 800 to 1000 bonus would be $ 100.

Please help, been trying to figure this out for a week. So glad I found this page.

Thanks in advance for any assistance!!

Candace

 

[Greg Truby]

Candace - you should be able to simply use the VLOOKUP function for something like this.

<!-- Please do not remove this header --><!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com) --><TABLE border=1 cellSpacing=0 borderColor=#c0c0c0 borderColorDark=#ffffff><TBODY><TR><TH style="WHITE-SPACE: nowrap" bgColor=#969696 height=26 vAlign=bottom width=63>Value</TH><TH style="WHITE-SPACE: nowrap" bgColor=#969696 height=26 vAlign=bottom width=93>Bonus</TH><TH style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right></TH><TH style="WHITE-SPACE: nowrap" bgColor=#c0c0c0 height=26 vAlign=bottom width=63>Bonus Table</TH><TH style="WHITE-SPACE: nowrap" bgColor=#c0c0c0 height=26 vAlign=bottom width=63 align=right></TH><TH style="WHITE-SPACE: nowrap" bgColor=#c0c0c0 height=26 vAlign=bottom width=78 align=right></TH></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>10</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93>=VLOOKUP(A2,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" bgColor=#666699 height=25 vAlign=bottom width=63>Low</TD><TD style="WHITE-SPACE: nowrap" bgColor=#666699 height=25 vAlign=bottom width=63>High</TD><TD style="WHITE-SPACE: nowrap" bgColor=#666699 height=25 vAlign=bottom width=78>Bonus</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>20</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93>=VLOOKUP(A3,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>0</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>=D4-1</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78>You’re fired</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>30</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93 align=right>=VLOOKUP(A4,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>25</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>=D5-1</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78 align=right>25</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>50</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93 align=right>=VLOOKUP(A5,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>50</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>=D6-1</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78 align=right>50</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>60</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93 align=right>=VLOOKUP(A6,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>100</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>=D7-1</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78 align=right>75</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>99</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93 align=right>=VLOOKUP(A7,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>800</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>=D8-1</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78 align=right>100</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right>100</TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=93 align=right>=VLOOKUP(A8,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right>1000</TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right>999999</TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=78 align=right>125</TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right>101</TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=93 align=right>=VLOOKUP(A9,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=78 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>798</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93 align=right>=VLOOKUP(A10,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>799</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93 align=right>=VLOOKUP(A11,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>800</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93 align=right>=VLOOKUP(A12,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>801</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93 align=right>=VLOOKUP(A13,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>999</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93 align=right>=VLOOKUP(A14,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right>1000</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=93 align=right>=VLOOKUP(A15,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=25 vAlign=bottom width=78 align=right></TD></TR><TR><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right>1001</TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=93 align=right>=VLOOKUP(A16,$D$3:$F$8,3,TRUE)</TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=63 align=right></TD><TD style="WHITE-SPACE: nowrap" height=26 vAlign=bottom width=78 align=right></TD></TR></TBODY></TABLE>

<!-- Please do not remove this header --><!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com) --><table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0"><tr><th bgcolor="#969696" width="63" height="26" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF">Value</font></th><th bgcolor="#969696" width="93" height="26" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF">Bonus</font></th><th width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></th><th bgcolor="#C0C0C0" width="63" height="26" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF">Bonus Table</font></th><th bgcolor="#C0C0C0" width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF"></font></th><th bgcolor="#C0C0C0" width="78" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF"></font></th></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">10</font></td><td width="93" height="25" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">You’re fired</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td bgcolor="#666699" width="63" height="25" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF">Low</font></td><td bgcolor="#666699" width="63" height="25" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF">High</font></td><td bgcolor="#666699" width="78" height="25" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#FFFFFF">Bonus</font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">20</font></td><td width="93" height="25" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">You’re fired</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">0</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">24</font></td><td width="78" height="25" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">You’re fired</font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">30</font></td><td width="93" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">25</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">25</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">49</font></td><td width="78" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">25</font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">50</font></td><td width="93" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">50</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">50</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">99</font></td><td width="78" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">50</font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">60</font></td><td width="93" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">50</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">100</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">799</font></td><td width="78" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">75</font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">99</font></td><td width="93" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">50</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">800</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">999</font></td><td width="78" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">100</font></td></tr><tr><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">100</font></td><td width="93" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">75</font></td><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1000</font></td><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">999999</font></td><td width="78" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">125</font></td></tr><tr><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">101</font></td><td width="93" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">75</font></td><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="78" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">798</font></td><td width="93" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">75</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="78" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">799</font></td><td width="93" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">75</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="78" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">800</font></td><td width="93" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">100</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="78" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">801</font></td><td width="93" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">100</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="78" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">999</font></td><td width="93" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">100</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="78" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td></tr><tr><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1000</font></td><td width="93" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">125</font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="78" height="25" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td></tr><tr><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1001</font></td><td width="93" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">125</font></td><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="63" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td><td width="78" height="26" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td></tr></table>

 

[candybcool]

Thank you! You’re a genius! It is perfect! Hope you have a great night. I know I will!!

Thanks again.


Candace