View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bookmdano Bookmdano is offline
external usenet poster
 
Posts: 16
Default Need assistance with a formula - If then???

I need to determine how often a number occurs in a range of cells above and
below a certain value. The range is 71 cells. I need to know how many times
the number is above 120 and below 120. I then need to know the percentange
of the range that was above 120 and below 120.