MIN (IF(

I am trying to create a formula that finds the minimum cellin a range, as long as one cell has a value (excludes zeros), then looks to another cell if all others in the MIN range are zeros.

I currently have this which finds the minumum but excludes zeros 

{=MIN(IF(M38:M44>0,M38:M44))}

What I think I need but it doesn’t work is this:

{=MIN(IF(M38:M44>0,M38:M44,M37))}

Any help would be greatly appreciated

 

By: Wylie

Leave a Reply

Your email address will not be published. Required fields are marked *