Min or Max, but ignore 0.00 if other cell has a value >0

[DRExcel515]

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)

Rating #1	Rating #2	Rating #3	Min Value
3.43	3.67	0.00	3.43 (Excludes the 0.00 somehow?)

<tbody>
</tbody>

Any help would be much appreciated!

Cheers

 

[Special-K99]

=MIN(IF(A1:C1>0,A1:C1))
Array formula, use Ctrl-Shift-Enter

 

[DRExcel515]

@Special-K99 thank you for the help! I ended up using IFERROR(SMALL(N9:R9,COUNTIF(N9:R9,0)+1),"Not Rated"). Appreciate the response!