hi Abid Raza,

if cell E12 = 34, outcome will 3 or 4?
if cell E12 = 41, outcome will 3 or 4?

--
isabelle



Le 2012-06-02 17:28, Abid Raza a écrit :
Spencer101;1602317 Wrote:
Hi,

I'm not sure I fully understand what you're trying to do here.

There appears to be an overlap. If the value in cell E12 was 34 to 41
it could fall within either of the two conditions and therefore could
result in either 4 or 3 in cell E15.

Which would it be?

If Cell E12 is between 33& 41 E15 should return 4
If Cell E12 is between 34& 42 E15 should return 3

O.K., Can we defined ranges as:
1. below 33 0 Point
2. 33-34 3 Point
3. 34-41 4 Point
4. 41-42 3 Point
5. Above 42 0 Point

Hope this makes easy to solve...........