View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Need assistance with a formula - If then???

Please don't multipost. Cross-post if you must.
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html
--
David Biddulph

"Bookmdano" wrote in message
...
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.