Thread: Looking for the smallest number that isn't less than zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CharlieS CharlieS is offline
external usenet poster
  
Posts: 7
Default Looking for the smallest number that isn't less than zero
Hello all! I have a formual set up to return the smallest number in a
column...
=SMALL($E$4:$E$104,1)
However, I need to to return the smallest number greater than zero. We have
a contest going on and based on sales vs. the employee guess we may have some
negative numbers come up so I don't want them to show in my top 5... Can you
help?
Reply With QuoteReply With Quote