Variable calculation question

  • Thread starter Thread starter EG
  • Start date Start date
E

EG

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
 
If column E contains the values 1,2,3 and Q2 contains the value 2, then the
first conditiion is true and 100 should be returned.

However, the second condition is ALSO true, and the ratio should be returned.

You need conditions that are mutually exclusive.
 
Back
Top