hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
I have 3 cells with values either 0 or a numerical value(non negative).
In 4th cell MINIMUM of the 3 cells are required without considering cells with 0 value.
Sheet1
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #ffff00"]Answer[/TD]
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]123.656[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]887.44[/TD]
[TD="align: right"]123.656[/TD]
</tbody>
How to accomplish?
Thanks in advance.
In 4th cell MINIMUM of the 3 cells are required without considering cells with 0 value.
Sheet1
A | B | C | D | |
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #ffff00"]Answer[/TD]
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]123.656[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]887.44[/TD]
[TD="align: right"]123.656[/TD]
</tbody>
How to accomplish?
Thanks in advance.