Thread
:
Conditional Format - MIN, IF statements
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Conditional Format - MIN, IF statements
Array formula that must be entered using ctrl+shift+enter
=MIN(IF(G2:G220,G2:G22))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett