Variable calculation question

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
 
G

Gary''s Student

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top