Hi, I'm trying the following,
I have the below data which needs to be copied below this data and each cell if larger than 0 in columns b-e multiplied with the corresponding value in column a.
<colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody>
</tbody>
I have the below data which needs to be copied below this data and each cell if larger than 0 in columns b-e multiplied with the corresponding value in column a.
a | b | c | d | e |
1.02 | 237 | 358 | 0 | 715 |
0.35 | 1 | 0 | 120 | 0 |
0.71 | 51 | 0 | 0 | 0 |
1.21 | 683 | 481 | 0 | 612 |
0.67 | 704 | 501 | 0 | 1002 |
1.07 | 372 | 325 | 300 | 650 |
1.07 | 350 | 325 | 55 | 650 |
<colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody>
</tbody>