I have a calculation i want to perform but am not sure how to do it. here it
is:

I have a number of cells in column "E" that have various different number
values from 1 - 100. I want a formula that tells me that if any of the
numbers in the cells of column E are equal or greater than the value in cell
Q2, then it will return a value of 100. but if any of the numbers are less
than the value in Q2, then i want to count the number of values in column E
that are = to the value in Q2 and then divide this by the number of values in
column D that = "W".

Hope this makes sense. Thanks in advance for your help.

EG