Thread: Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Formula

"Garry Oder" wrote:
Can anyone assit with a formula for detirmining if a
number in a group of 20 is one of the lowest 8.


=IF(F1<=SMALL(F$1:F$20,8),"yes","no")