Thread: how do i calculate minumum but 0 (zero) must not show as the min
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default how do i calculate minumum but 0 (zero) must not show as the min
=IF(MIN(rng)=0,"",MIN(rng))

--
__________________________________
HTH

Bob

"minimum" wrote in message
...



Reply With QuoteReply With Quote