Glenn wrote...
It returned 0.00, or you think it will so you didn't try it?

msao wrote:
still will return 0.00 as the lowest number

"Mike H" wrote:
Try this ARRAY formula

=MIN(IF(A1:A200.01,A1:A20))
....
"msao" wrote:

Need to take a colum and find the smallest number in it but it must be
greater than 0.01 any help would be great

Mike's array formula would return 0 if there were no values in A1:A20
0.01.

If there are no numbers in A1:A20 greater than or equal to 0.01, what
should the formula return? If blank,

=IF(COUNTIF(A1:A20,"0.01"),LARGE(A1:A20,COUNTIF(A 1:A20,"0.01")),"")

or for Excel 2007 & later

=IFERROR(LARGE(A1:A20,COUNTIF(A1:A20,"0.01")),"")

OTOH, if it should return 0.01,

=MAX(0.01,MIN(A1:A20))