You don't need the 1000, Rick, you can just use

=MIN(MIN(IF(F19:F210,F19:F21)),IF(F270,F27))

"Rick Rothstein (MVP - VB)" wrote:

Either of the other two responses will work for you (change Don's ranges to
match Biff's) if there are no values in F22:F26; however, if there are
values there, then I'm not sure whether they can be modified, as posted, to
skip them. I'm sure there must be a better way but, off the top of my head,
the following formula seems to work...

=MIN(MIN(IF(F19:F210,F19:F21)),IF(F270,F27,1000) )

Note this formula must be committed by pressing Ctrl+Shift+Enter.

The 1000 in the last number just needs to be a number that will be larger
than any possible entry into the cells being tested.

Rick


"bob" wrote in message
...
Cells F19 through F21 have values of 4.09, 3.70, and 3.77, respectively.
F27
has a value of zero. I want to set up a formula in F100 that identifies
the
lowest value in these 4 cells excluding values that are zero. The answer
in
this case should be 3.70.

Can anyone help?

Thanks,
Bob