MS Excel more help

[ThePoor]

Hi All,

My new question:
For example: I have the following data:

70
70
80
50
60
85

How to I calculate the percentage of data that greater than or equal to 70?

Thank you in advance for all your help.

[Marc]

Assuming your data is in column A:

First create a column with the following coding in the first row: =IF(A1>=70,1,0) , then copy and paste this to subsequent rows in the column.

Then at the bottom of this new column (Column B): =AVERAGE(B1:B6)

This will be your percentage greater than or equal to 70.