What if there are 2 values with zero?

--
Regards,

Peo Sjoblom

(No private emails please)


"Cutter" wrote in
message ...

How about:

=IF(MIN(F16,K16,P16,Z16)=0,SMALL((F16,K16,P16,Z16) ,2),MIN(F16,K16,P16,Z16))


--
Cutter
------------------------------------------------------------------------
Cutter's Profile:
http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=488953