# Calculating Bonus

#### candybcool

##### New Member
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.

Thanks in advance for any assistance!!

Candace

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### Greg Truby

##### MrExcel MVP
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

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

Thanks again.

Candace