View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
SteveG
 
Posts: n/a
Default trying to make a formula for percent if greater than a value


Enter the formula as you normally would.


=AVERAGE(IF(A1:A80,A1:A8,FALSE))

When you are done typing in the formula, rather than hitting the Enter
key, hit the Ctrl, Shift & Enter keys simultaneously. That will create
the {} around the formula automatically. Don't type them in yourself.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=499913