If condition help needed

[Azarudeen]

Hi All,I have the below 3 columns and column B and C are the target value.If YTC is >=65 and STC>= 70, Need to have the value as 10 in column DAny one of the above condition met, then the result must be 5 else 0If YTC is >=55 and STC>= 55, Need to have the value as 10 in column DAny one of the above condition met, then the result must be 5 else 0If YTC is >=75 and STC>= 80, Need to have the value as 10 in column DAny one of the above condition met, then the result must be 5 else 0Name YTC STCJohn 65 70Susan 55 55Batt 65 70Matthew 65 70Kevin 75 80Mass 55 55Keith 75 80Can someone help me on this

 

[Azarudeen]

Sorry typo error


<CODE>

If YTC is >=65 and STC>= 70, Need to have the value as 10 in column D
Any one of the above condition met, then the result must be 5 else 0
If YTC is >=55 and STC>= 55, Need to have the value as 10 in column D
Any one of the above condition met, then the result must be 5 else 0
If YTC is >=75 and STC>= 80, Need to have the value as 10 in column D
Any one of the above condition met, then the result must be 5 else 0


[TABLE="width: 249"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]YTC[/TD]
[TD]STC[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]65[/TD]
[TD]70[/TD]
[/TR]
[TR]
[TD]Susan[/TD]
[TD]55[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]Batt[/TD]
[TD]65[/TD]
[TD]70[/TD]
[/TR]
[TR]
[TD]Matthew[/TD]
[TD]65[/TD]
[TD]70[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]75[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]Mass[/TD]
[TD]55[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]Keith[/TD]
[TD]75[/TD]
[TD]80[/TD]
[/TR]
</tbody>[/TABLE]
</CODE>

 

[Azarudeen]

Can someone help me with this. I need to validate

 

[Peter_SSs]

Your question is not clear to me (& I suspect others since no answer).

Can you post your sample data again, but also include the expected results & try explaining again using different words?