How can I make Excel's MIN function ignore zeroes in a set?

Posted by mfg on Stack Overflow See other posts from Stack Overflow or by mfg
Published on 2011-01-07T17:44:51Z Indexed on 2011/01/07 17:53 UTC
Read the original article Hit count: 270

Filed under:
|

In Excel, I have the following formula =(MIN(H69,H52,H35,H18)*(1/H18))*10 that is supposed to return the MIN of a range, and divide it by the current cell (*(1/H18) ), then multiply by 10.

I am having difficulty with adding a type of NULLIF statement. I want to be able to have (the possibility for) blank rows, and have the MIN function ignore zero/blank fields while selecting the next lowest value (all are between 1.0-0.1).

Is there a modifier i can apply to the MIN function to make it not compare zeroes in the MIN set? Is there a better funtion than MIN to use?

  • This is to prevent the following situation: users will need to eliminate fields that are zeros from the form, theres 2 formula edits per entry, averaging 4 entries per use, so 8 possible errors per form use...

© Stack Overflow or respective owner

Related posts about excel

Related posts about min