Formula required to get highest value from a range

[hsandeep]

Input Range:C2:M2
By default C2:M2 is either 0 or “” (null)
Else positive integer

Formula required in A2: HIGHEST value from C2:M2
If ALL values in C2:M2=0, negative (less than 0) or null, A2 should be “” (null)
How to accomplish?
Thanks very much for your time given & help in advance.

A

B

C

D

E

F

G

H

I

J

K

L

M

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"><col style="WIDTH: 26px"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="bgcolor: #ffff00, align: right"]100[/TD]

[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]18[/TD]
[TD="bgcolor: #ffff00, align: right"]100[/TD]
[TD="align: right"]7[/TD]

</tbody>

 

[Scott T]

=if(max(c2:m2)<=0,"",max(c2:m2))