Mass Formula with IF & LOOKUP

Finalmakerr · Aug 5, 2011

Hello,

Formula: =IF(LOOKUP("$",G10,F10),F10*$K$3,IF(LOOKUP("€",G10,F10),F10*$K$4,IF(LOOKUP("₪",G10,F10),F10,"")))

Issue : Only the first "IF" is working properly while the rest result in N/A#

Formula goal: Currency check and exchange

Further details:

CELL G ($,€,₪) = CURRENCY TYPE
CELL F = PRICE
CELL K = CURRENCY RATE

Thanks in advance,

Gal

Finalmakerr · Aug 11, 2011

Hey again,

Thanks for your help.
I need your help for fixing the follow formula:
=SUMIF(OR($J8:$J21,$J8:$J21),OR($,€),"F8:F21")

There's seem to be an error with the second "OR"!

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 74px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>F</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">10.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-WEIGHT: bold">10.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">10.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">180.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-WEIGHT: bold">215.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">250.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold">250.00</TD></TR><TR style="HEIGHT: 35px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">250.00</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; BORDER-LEFT-STYLE: groove; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>F22</TD><TD>=IF($J$22="¤",(SUMIF($J8:$J21,"¤",F8:F21)+(SUMIF($J8:$J21,"$",F8:F21)*$K$3)+(SUMIF($J8:$J21,"€",F8:F21)*$K$4)),IF($J$22="$",(SUMIF($J8:$J21,"¤",F8:F21)/$K$3)+(SUMIF($J8:$J21,"$",F8:F21))+(SUMIF($J8:$J21,"€",F8:F21)*($K$4-$K$3)),IF($J$22="€",SUMIF($J8:$J21,"¤",F8:F21)/$K$4)+(SUMIF($J8:$J21,"$",F8:F21)/($K$4-$K$3))+(SUMIF($J8:$J21,"€",F8:F21))))</TD></TR><TR><TD>F29</TD><TD>=IF($J29="¤",(SUMIF($J23:$J28,"¤",F23:F28)+(SUMIF($J23:$J28,"$",F23:F28)*$K$3)+(SUMIF($J23:$J28,"€",F23:F28)*$K$4)),IF($J29="$",(SUMIF($J23:$J28,"¤",F23:F28)/$K$3)+(SUMIF($J23:$J28,"$",F23:F28))+(SUMIF($J23:$J28,"€",F23:F28)*($K$4-$K$3)),IF($J29="€",SUMIF($J23:$J28,"¤",F23:F28)/$K$4)+(SUMIF($J23:$J28,"$",F23:F28)/($K$4-$K$3))+(SUMIF($J23:$J28,"€",F23:F28))))</TD></TR><TR><TD>F41</TD><TD>=IF($J41="¤",(SUMIF($J30:$J40,"¤",F30:F40)+(SUMIF($J30:$J40,"$",F30:F40)*$K$3)+(SUMIF($J30:$J40,"€",F30:F40)*$K$4)),IF($J41="$",(SUMIF($J30:$J40,"¤",F30:F40)/$K$3)+(SUMIF($J30:$J40,"$",F30:F40))+(SUMIF($J30:$J40,"€",F30:F40)*($K$4-$K$3)),IF($J41="€",SUMIF($J30:$J40,"¤",F30:F40)/$K$4)+(SUMIF($J30:$J40,"$",F30:F40)/($K$4-$K$3))+(SUMIF($J30:$J40,"€",F30:F40))))</TD></TR><TR><TD>F49</TD><TD>=IF($J49="¤",(SUMIF($J42:$J48,"¤",F42:F48)+(SUMIF($J42:$J48,"$",F42:F48)*$K$3)+(SUMIF($J42:$J48,"€",F42:F48)*$K$4)),IF($J49="$",(SUMIF($J42:$J48,"¤",F42:F48)/$K$3)+(SUMIF($J42:$J48,"$",F42:F48))+(SUMIF($J42:$J48,"€",F42:F48)*($K$4-$K$3)),IF($J49="€",SUMIF($J42:$J48,"¤",F42:F48)/$K$4)+(SUMIF($J42:$J48,"$",F42:F48)/($K$4-$K$3))+(SUMIF($J42:$J48,"€",F42:F48))))</TD></TR><TR><TD>F50</TD><TD>=IF($J50="¤",(IF($J$22="$",F22*$K$3)+(IF($J$22="€",F22*$K$4))+(IF($J$22="¤",F22)))+(IF($J$29="$",F29*$K$3)+(IF($J$29="€",F29*$K$4))+(IF($J$29="¤",F29)))+(IF($J$41="$",F41*$K$3)+(IF($J$41="€",F41*$K$4))+(IF($J$41="¤",F41))))+IF($J50="$",(IF($J$22="$",F22)+(IF($J$22="€",F22*($K$4-$K$3)))+(IF($J$22="¤",F22/$K$3)))+(IF($J$29="$",F29)+(IF($J$29="€",F29*($K$4-$K$3)))+(IF($J$29="¤",F29/$K$3))+(IF($J$41="$",F41))+(IF($J$41="€",F41*($K$4-$K$3)))+(IF($J$41="¤",F41/$K$3))))+IF($J50="€",(IF($J$22="$",F22/($K$4-$K$3))+(IF($J$22="€",F22))+(IF($J$22="¤",F22/$K$4)))+(IF($J$29="$",F29/($K$4-$K$3))+(IF($J$29="€",F29))+(IF($J$29="¤",F29/$K$4))+(IF($J$41="$",F41/($K$4-$K$3))+(IF($J$41="€",F41))+(IF($J$41="¤",F41/$K$4)))))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Finalmakerr · Aug 12, 2011

Marcol said:
What version of Excel are you using?

Software: Excel 2007 (12.0.6557.5000) SP2 MSO (12.0.6554.5001)
File Output: Version 2003

Marcol · Aug 12, 2011

Re:
=SUMIF(OR($J8:$J21,$J8:$J21),OR($,€),"F8:F21")
SUMIF() will not accept these arguements

Your sample doesn't show Column J, but at a guess from earlier posts, maybe this
=SUMIF($J8:$J21,"<>₪",$F8:$F21)
or
=SUMPRODUCT(--($J8:$J21="$")+--($J8:$J21="€"),$F8:$F21)

Finalmakerr · Aug 12, 2011

=SUMPRODUCT(--($J$8:$J$21="$")+--($J$23:$J$28="$")+--($J$30:$J$40="$"),F$8:F$21,F$23:F$28,F$30:F$40)

result is N/A#

Marcol · Aug 12, 2011

With SUMPRODUCT() all the ranges must be the same size.

I don't understand why you can't add the extra columns as I suggested in Post #7.
Good sheet layout at the beginning of a project saves much head scratching later on, as you seem to be finding out now.

What exactly are you trying to do?

Are you still trying to solve the problem with the layout in your original post?

If so try this
(Just add 7 rows at the top to match your sheet.)
Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 89px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="BACKGROUND-COLOR: #000000; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-WEIGHT: bold">CURRENCY</TD><TD style="BACKGROUND-COLOR: #000000; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-WEIGHT: bold">RATE</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-WEIGHT: bold">PRICE</TD><TD style="BACKGROUND-COLOR: #000000; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-WEIGHT: bold">CURRENCY</TD></TR><TR style="HEIGHT: 21px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Verdana">$</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana">3.5</TD><TD style="FONT-FAMILY: Verdana"></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Verdana">€</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana">5</TD><TD style="FONT-FAMILY: Verdana"></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">€</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">6.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">€</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">5.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">€</TD></TR><TR style="HEIGHT: 21px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">5.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">1.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">11</TD><TD></TD><TD>Sub Total</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">10.40</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">€</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">€</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">1.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">2.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">1.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD></TD><TD></TD><TD></TD><TD>Sub Total</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">0.80</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">€</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">1.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">5.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">5.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">5.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">2.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD></TD><TD></TD><TD></TD><TD>Sub Total</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">30.50</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">1.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD></TD><TD></TD><TD></TD><TD>Sub Total</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">0.20</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">€</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">17.50</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 13pt; FONT-WEIGHT: bold">€</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; BORDER-LEFT-STYLE: groove; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>E17</TD><TD>=SUMPRODUCT(--(J2:J16="$")+--(J2:J16="€"),I2:I16)</TD></TR><TR><TD>F17</TD><TD>=SUMIF($J2:$J16,"<>?",I2:I16)</TD></TR><TR><TD>I17</TD><TD>=(SUMIF(J2:J16,"?",I2:I16)+(SUMIF(J2:J16,"$",I2:I16)*$F$2)+(SUMIF(J2:J16,"€",I2:I16)*$F$3))/IF(J17="€",$F$3,IF(J17="$",$F$2,1))</TD></TR><TR><TD>I24</TD><TD>=(SUMIF(J18:J23,"?",I18:I23)+(SUMIF(J18:J23,"$",I18:I23)*$F$2)+(SUMIF(J18:J23,"€",I18:I23)*$F$3))/IF(J24="€",$F$3,IF(J24="$",$F$2,1))</TD></TR><TR><TD>I34</TD><TD>=(SUMIF(J25:J33,"?",I25:I33)+(SUMIF(J25:J33,"$",I25:I33)*$F$2)+(SUMIF(J25:J33,"€",I25:I33)*$F$3))/IF(J34="€",$F$3,IF(J34="$",$F$2,1))</TD></TR><TR><TD>I44</TD><TD>=(SUMIF(J35:J43,"?",I35:I43)+(SUMIF(J35:J43,"$",I35:I43)*$F$2)+(SUMIF(J35:J43,"€",I35:I43)*$F$3))/IF(J44="€",$F$3,IF(J44="$",$F$2,1))</TD></TR><TR><TD>I46</TD><TD>=(SUMIF(J2:J44,"?",I2:I44)+(SUMIF(J2:J44,"$",I2:I44)*$F$2)+(SUMIF(J2:J44,"€",I2:I44)*$F$3))/IF(J46="€",$F$3,IF(J46="$",$F$2,1))/2</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Hope this helps

Finalmakerr · Aug 15, 2011

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 74px"><COL style="WIDTH: 74px"><COL style="WIDTH: 74px"><COL style="WIDTH: 74px"><COL style="WIDTH: 35px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">400.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">800.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">800.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">184.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">368.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">368.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">9.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">€</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">15.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">30.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">30.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">15.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">15.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">15.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">€</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-WEIGHT: bold">27.86</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-WEIGHT: bold">645.50</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-WEIGHT: bold">1258.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-WEIGHT: bold">1258.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt; FONT-WEIGHT: bold">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">€</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">620.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">730.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">€</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold">6.67</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold">620.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold">730.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt; FONT-WEIGHT: bold">€</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">43.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">43.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">43.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">158.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">248.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">248.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">20.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">20.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">20.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">180.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">180.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">180.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">180.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">760.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">880.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">880.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-WEIGHT: bold">215.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-WEIGHT: bold">1791.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-WEIGHT: bold">2226.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-WEIGHT: bold">2226.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">₪</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt; FONT-WEIGHT: bold">₪</TD></TR><TR style="HEIGHT: 35px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">345.83</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">7150.25</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">10279.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">6629.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 13pt; FONT-WEIGHT: bold">₪</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 10pt">0.00</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 10pt">0.00</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 10pt">0.00</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 10pt">0.00</TD><TD style="TEXT-ALIGN: center">₪</TD></TR></TBODY></TABLE>

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 74px"><COL style="WIDTH: 35px"><COL style="WIDTH: 80px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>I</TD><TD>J</TD><TD>K</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>שער äדולר - שקל</TD><TD> </TD><TD style="TEXT-ALIGN: center">3.500</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>שער äיורו - שקל</TD><TD> </TD><TD style="TEXT-ALIGN: center">5.000</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right" colSpan=2>עמלת מט"ח</TD><TD style="TEXT-ALIGN: center">1.50%</TD></TR></TBODY></TABLE>

F51 = IF J51 equal to "₪" then sum F$8:F$21,F$23:F$28,F$30:F$40 if thier following "J" equal to "$" then double thier sum with "K3" then double with "K5" + sum F$8:F$21,F$23:F$28,F$30:F$40 if thier following "J" equal to "€".

Thanks a lot,

Gal

Marcol · Aug 15, 2011

What is the 1.50% in K5 for?

Sheet1
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 117px"><COL style="WIDTH: 117px"><COL style="WIDTH: 117px"><COL style="WIDTH: 117px"><COL style="WIDTH: 86px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #000000; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-WEIGHT: bold">CURRENCY</TD><TD></TD><TD style="BACKGROUND-COLOR: #000000; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-WEIGHT: bold">RATE</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">I</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">J</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">K</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-FAMILY: Verdana">??? ä???? - ???</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana">3.5</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-FAMILY: Verdana">??? ä???? - ???</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana">5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana" colSpan=2>???? ??"?</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana">1.50%</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">F</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">G</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">H</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">I</TD><TD style="BACKGROUND-COLOR: #000000; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-WEIGHT: bold">CURRENCY</TD><TD></TD></TR><TR style="HEIGHT: 21px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">400.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">800.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">800.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">184.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">368.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">368.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">9.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">€</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">15.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">30.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">30.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">15.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">15.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">15.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">€</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff8080; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">27.14</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff8080; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">644.86</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff8080; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">1256.71</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff8080; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">1256.71</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff8080; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">$</TD><TD>Sub Total</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">€</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">620.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">730.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">€</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff9900; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">7.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff9900; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">620.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff9900; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">730.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff9900; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff9900; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">€</TD><TD>Sub Total</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">43.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">43.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">43.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">158.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">248.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">248.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">20.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">20.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">20.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">$</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">180.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">180.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">180.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">180.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">760.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">880.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">880.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #339966; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">215.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #339966; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">1791.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #339966; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">2226.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #339966; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">2226.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #339966; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">?</TD><TD>Sub Total</TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 20px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00ffff; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00ffff; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00ffff; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00ffff; FONT-FAMILY: Verdana; FONT-WEIGHT: bold">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00ffff; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">?</TD><TD>Sub Total</TD></TR><TR style="HEIGHT: 21px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">595.00</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">7398.00</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">10524.50</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 12pt; FONT-WEIGHT: bold">6874.50</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 13pt; FONT-WEIGHT: bold">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; COLOR: #0066cc">0.00</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; COLOR: #0066cc">0.00</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; COLOR: #0066cc">0.00</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; COLOR: #0066cc">0.00</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana">?</TD><TD style="FONT-FAMILY: Verdana"></TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; BORDER-LEFT-STYLE: groove; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>F22</TD><TD>=(SUMIF($J$8:$J$21,"?",F8:F21)+(SUMIF($J$8:$J$21,"$",F8:F21)*$K$3)+(SUMIF($J$8:$J$21,"€",F8:F21)*$K$4))/IF($J$22="€",$K$4,IF($J$22="$",$K$3,1))</TD></TR><TR><TD>G22</TD><TD>=(SUMIF($J$8:$J$21,"?",G8:G21)+(SUMIF($J$8:$J$21,"$",G8:G21)*$K$3)+(SUMIF($J$8:$J$21,"€",G8:G21)*$K$4))/IF($J$22="€",$K$4,IF($J$22="$",$K$3,1))</TD></TR><TR><TD>H22</TD><TD>=(SUMIF($J$8:$J$21,"?",H8:H21)+(SUMIF($J$8:$J$21,"$",H8:H21)*$K$3)+(SUMIF($J$8:$J$21,"€",H8:H21)*$K$4))/IF($J$22="€",$K$4,IF($J$22="$",$K$3,1))</TD></TR><TR><TD>I22</TD><TD>=(SUMIF($J$8:$J$21,"?",I8:I21)+(SUMIF($J$8:$J$21,"$",I8:I21)*$K$3)+(SUMIF($J$8:$J$21,"€",I8:I21)*$K$4))/IF($J$22="€",$K$4,IF($J$22="$",$K$3,1))</TD></TR><TR><TD>F29</TD><TD>=(SUMIF($J$23:$J$28,"?",F23:F28)+(SUMIF($J$23:$J$28,"$",F23:F28)*$K$3)+(SUMIF($J$23:$J$28,"€",F23:F28)*$K$4))/IF($J$29="€",$K$4,IF($J$29="$",$K$3,1))</TD></TR><TR><TD>G29</TD><TD>=(SUMIF($J$23:$J$28,"?",G23:G28)+(SUMIF($J$23:$J$28,"$",G23:G28)*$K$3)+(SUMIF($J$23:$J$28,"€",G23:G28)*$K$4))/IF($J$29="€",$K$4,IF($J$29="$",$K$3,1))</TD></TR><TR><TD>H29</TD><TD>=(SUMIF($J$23:$J$28,"?",H23:H28)+(SUMIF($J$23:$J$28,"$",H23:H28)*$K$3)+(SUMIF($J$23:$J$28,"€",H23:H28)*$K$4))/IF($J$29="€",$K$4,IF($J$29="$",$K$3,1))</TD></TR><TR><TD>I29</TD><TD>=(SUMIF($J$23:$J$28,"?",I23:I28)+(SUMIF($J$23:$J$28,"$",I23:I28)*$K$3)+(SUMIF($J$23:$J$28,"€",I23:I28)*$K$4))/IF($J$29="€",$K$4,IF($J$29="$",$K$3,1))</TD></TR><TR><TD>F41</TD><TD>=(SUMIF($J$30:$J$40,"?",F30:F40)+(SUMIF($J$30:$J$40,"$",F30:F40)*$K$3)+(SUMIF($J$30:$J$40,"€",F30:F40)*$K$4))/IF($J$41="€",$K$4,IF($J$41="$",$K$3,1))</TD></TR><TR><TD>G41</TD><TD>=(SUMIF($J$30:$J$40,"?",G30:G40)+(SUMIF($J$30:$J$40,"$",G30:G40)*$K$3)+(SUMIF($J$30:$J$40,"€",G30:G40)*$K$4))/IF($J$41="€",$K$4,IF($J$41="$",$K$3,1))</TD></TR><TR><TD>H41</TD><TD>=(SUMIF($J$30:$J$40,"?",H30:H40)+(SUMIF($J$30:$J$40,"$",H30:H40)*$K$3)+(SUMIF($J$30:$J$40,"€",H30:H40)*$K$4))/IF($J$41="€",$K$4,IF($J$41="$",$K$3,1))</TD></TR><TR><TD>I41</TD><TD>=(SUMIF($J$30:$J$40,"?",I30:I40)+(SUMIF($J$30:$J$40,"$",I30:I40)*$K$3)+(SUMIF($J$30:$J$40,"€",I30:I40)*$K$4))/IF($J$41="€",$K$4,IF($J$41="$",$K$3,1))</TD></TR><TR><TD>F49</TD><TD>=(SUMIF($J$42:$J$48,"?",F42:F48)+(SUMIF($J$42:$J$48,"$",F42:F48)*$K$3)+(SUMIF($J$42:$J$48,"€",F42:F48)*$K$4))/IF($J$49="€",$K$4,IF($J$49="$",$K$3,1))</TD></TR><TR><TD>G49</TD><TD>=(SUMIF($J$42:$J$48,"?",G42:G48)+(SUMIF($J$42:$J$48,"$",G42:G48)*$K$3)+(SUMIF($J$42:$J$48,"€",G42:G48)*$K$4))/IF($J$49="€",$K$4,IF($J$49="$",$K$3,1))</TD></TR><TR><TD>H49</TD><TD>=(SUMIF($J$42:$J$48,"?",H42:H48)+(SUMIF($J$42:$J$48,"$",H42:H48)*$K$3)+(SUMIF($J$42:$J$48,"€",H42:H48)*$K$4))/IF($J$49="€",$K$4,IF($J$49="$",$K$3,1))</TD></TR><TR><TD>I49</TD><TD>=(SUMIF($J$42:$J$48,"?",I42:I48)+(SUMIF($J$42:$J$48,"$",I42:I48)*$K$3)+(SUMIF($J$42:$J$48,"€",I42:I48)*$K$4))/IF($J$49="€",$K$4,IF($J$49="$",$K$3,1))</TD></TR><TR><TD>F50</TD><TD>=(SUMIF($J$8:$J$49,"?",F8:F49)+(SUMIF($J$8:$J$49,"$",F8:F49)*$K$3)+(SUMIF($J$8:$J$49,"€",F8:F49)*$K$4))/IF($J$50="€",$K$4,IF($J$50="$",$K$3,1))/2</TD></TR><TR><TD>G50</TD><TD>=(SUMIF($J$8:$J$49,"?",G8:G49)+(SUMIF($J$8:$J$49,"$",G8:G49)*$K$3)+(SUMIF($J$8:$J$49,"€",G8:G49)*$K$4))/IF($J$50="€",$K$4,IF($J$50="$",$K$3,1))/2</TD></TR><TR><TD>H50</TD><TD>=(SUMIF($J$8:$J$49,"?",H8:H49)+(SUMIF($J$8:$J$49,"$",H8:H49)*$K$3)+(SUMIF($J$8:$J$49,"€",H8:H49)*$K$4))/IF($J$50="€",$K$4,IF($J$50="$",$K$3,1))/2</TD></TR><TR><TD>I50</TD><TD>=(SUMIF($J$8:$J$49,"?",I8:I49)+(SUMIF($J$8:$J$49,"$",I8:I49)*$K$3)+(SUMIF($J$8:$J$49,"€",I8:I49)*$K$4))/IF($J$50="€",$K$4,IF($J$50="$",$K$3,1))/2</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Finalmakerr · Aug 16, 2011

Hey Marcol,

I am only trying to figure out how to do the F51 cell and not the rest of the cells you have posted. The 1.5% in cell K5 is the commision rate for any type of coin that is different from J51.

Thanks again,

Gal

Marcol · Aug 16, 2011

As I stated earlier, your sheet is not very efficiently laid out, nor is your requirement entirely clear.
Are you not confusing K5 with K4?

The formulae in row 50 do as you seem to be asking for the whole table in your sample. i.e. F8:I49

If you don't want to include F42:F49 and get a result in F51 then try this
In F51

Code:

=(SUMIF($J$8:$J$41,"₪",F8:F41)+(SUMIF($J$8:$J$41,"$",F8:F41)*$K$3)+(SUMIF($J$8:$J$41,"€",F8:F41)*$K$4))/IF($J$51="€",$K$4,IF($J$51="$",$K$3,1))/2

Drag Across to I51

I have no idea, from what you have said so far, what to do with the commission figure in K5, presumably you multiply the results in any required row by this figure.

Finalmakerr · Aug 24, 2011

COMMISION

</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">1.50%</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="FONT-SIZE: 12pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-SIZE: 12pt; FONT-WEIGHT: bold"> </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">800.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">368.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">€</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">18.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">30.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">15.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt">€</TD><TD> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-WEIGHT: bold">1258.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 12pt; FONT-WEIGHT: bold">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">€</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt">€</TD><TD> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-WEIGHT: bold">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-SIZE: 12pt; FONT-WEIGHT: bold">€</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">43.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">248.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">20.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">10.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">$</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">180.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">880.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">75.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-WEIGHT: bold">2226.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff">0.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt">¤</TD><TD> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-WEIGHT: bold">250.00</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffff; FONT-SIZE: 12pt; FONT-WEIGHT: bold">¤</TD><TD> </TD></TR><TR style="HEIGHT: 35px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">6629.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 13pt; FONT-WEIGHT: bold">¤</TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 10pt">0.00</TD><TD style="TEXT-ALIGN: center">¤</TD><TD> </TD></TR></TBODY></TABLE>

As i told you before i have manage to fix everything but this J51! What i am trying to do is to make a formula that check if J51 = "₪" and if so then sum the follow cells I8:I21+I23:I28+I43:I40 while checking that thier "J" cell is different then "₪" and seperating the "$" and "€" in thier "J" so i can multiply both of them in seperate with K5 (i only want the value of the extra 1.5%.
I intend to make it more complex then that but i first have to figure out the first step.

Mass Formula with IF & LOOKUP

Finalmakerr

New Member

Finalmakerr

New Member

Excel Facts

Finalmakerr

New Member

Marcol

Well-known Member

Finalmakerr

New Member

Marcol

Well-known Member

Finalmakerr

New Member

Marcol

Well-known Member

Finalmakerr

New Member

Marcol

Well-known Member

Finalmakerr

New Member

Similar threads

Forum statistics

Share this page

Mass Formula with IF & LOOKUP

New Member

New Member

Excel Facts

New Member

Well-known Member

New Member

Well-known Member

New Member

Well-known Member

New Member

Well-known Member

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock