MIN of Range Where Values Are Greater Than Zero?

[aedctalk]

Hello!

I'm trying to get min of the following range so it only shows any value so long as the value is something above zero

={MIN(IF($U$112:$AS$112>0,$U$112:$AS$112))}

However it keeps displaying 0 in the cell i have this formula in. What am i doing wrong? or is there another method/way?

Thanks!

 

[njimack]

MIN(IF(ROUND($U$112:$AS$112,0)>0,$U$112:$AS$112))</pre>

 

[aedctalk]

hmm both of these are still showing 0 as the value in the cell. when the end goal i'm trying to get is any number higher than zero that is the smallest to show up.

Do i need maybe to do the IF $U$112:$AS$112>0 part first then the MIN?

Would that work? How could i set that one up?

Thank you so much for the help!

 

[T. Valko]

Hello!

I'm trying to get min of the following range so it only shows any value so long as the value is something above zero

={MIN(IF($U$112:$AS$112>0,$U$112:$AS$112))}


However it keeps displaying 0 in the cell i have this formula in. What am i doing wrong? or is there another method/way?

Thanks!

Are you sure there is a number greater than 0 in the range?

Are you sure there are NUMERIC numbers in the range?

What results do you get from these formulas:

=COUNT(U112:AS112)

=COUNTIF(U112:AS112,">0")

 

[MrVillareal]

I suspect there is something like 0.01 or something. Try increasing the decimals in the cell formula..

 

[MrVillareal]

Or try to post the data you are solving.