Thread: calculate percentage of numbers <= zero in a given range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
spowel4 spowel4 is offline
external usenet poster
  
Posts: 2
Default calculate percentage of numbers <= zero in a given range
I need to calculate the percentage of numbers, within a range of
cells, that are equal to zero or less than zero.

Simple example: numbers are 8, -1, 8, 8, 0, 0

The percentage of numbers that are equal to zero or less than zero
would be 3/6 or 50%

How can I do this in Excel?
Reply With QuoteReply With Quote