DRExcel515
Board Regular
- Joined
- Oct 20, 2017
- Messages
- 56
I have three cells that each have a numeric rating. What I want to do is bring back the min/lowest value of the three ratings. With the exception of where one of the ratings is 0.00 but the one of the other two has a value >0.
In other words if there are three ratings (below)[TABLE="width: 500"]
<tbody>[TR]
[TD]Rating #1
[/TD]
[TD]Rating #2[/TD]
[TD]Rating #3[/TD]
[TD]Min Value[/TD]
[/TR]
[TR]
[TD]3.43[/TD]
[TD]3.67[/TD]
[TD]0.00[/TD]
[TD]3.43 (Excludes the 0.00 somehow?)[/TD]
[/TR]
</tbody>[/TABLE]
Any help would be much appreciated!
Cheers
In other words if there are three ratings (below)[TABLE="width: 500"]
<tbody>[TR]
[TD]Rating #1
[/TD]
[TD]Rating #2[/TD]
[TD]Rating #3[/TD]
[TD]Min Value[/TD]
[/TR]
[TR]
[TD]3.43[/TD]
[TD]3.67[/TD]
[TD]0.00[/TD]
[TD]3.43 (Excludes the 0.00 somehow?)[/TD]
[/TR]
</tbody>[/TABLE]
Any help would be much appreciated!
Cheers