Thread: Output in Column A based on Input in Column B
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Output in Column A based on Input in Column B
Not sure if this is what you are looking for. This formual will print
a blank for any non-number value in column B. It will print "No" for
any number that is less than the median or halfway point in the
distribution.

=IF(ISNUMBER(B2),IF(B2<MEDIAN($B$2:$B$10),"No","Ye s"),"")

- John
www.JohnMichl.com

Reply With QuoteReply With Quote