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

Name	YTC	STC
John	65	70
Susan	55	55
Batt	65	70
Matthew	65	70
Kevin	75	80
Mass	55	55
Keith	75	80

<colgroup><col><col><col></colgroup><tbody>
</tbody>

</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?