Quote:
Originally Posted by Abid Raza
Please help to Create Formula for Below:
I have to put Marks for result obtain.
If Cell E12 is between 33 & 41 E15 should return 4
If Cell E12 is between 34 & 42 E15 should return 3
Please help........................
|
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?