If formula problem...

hi all,

how to figure it out this problem, like this below :

<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style><table class="tableizer-table">
<tr class="tableizer-firstrow"><th>data1</th><th>data2</th><th>after formula</th></tr>
<tr><td>-</td><td>-</td><td>-</td></tr>
<tr><td>-</td><td>BRI</td><td>BRI</td></tr>
<tr><td>KPKNL</td><td>-</td><td>KPKNL</td></tr>
<tr><td>-</td><td>BRI</td><td>BRI</td></tr>
<tr><td>KPKNL</td><td>-</td><td>KPKNL</td></tr>
</table>

see my workbook attached..

any help me, much appreciated...

john m

hi, thanks all of you.....