Quote:
Originally Posted by Spencer101
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...........