If condition

[bhandari]

[TABLE="width: 500"]
<tbody>[TR]
[TD]SSD[/TD]
[TD]PSD[/TD]
[TD]HSD[/TD]
[TD]K[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]73.6[/TD]
[TD]134[/TD]
[TD]41[/TD]
[TD]118[/TD]
[TD]IF(OR(AND(K>=73.6(SSD),K>=41(HSD)),AND(K>=134(PSD),"1 CONDITION=ACCEPTED THEN TAKE "K"VALUE IS ACCEPTED,2-CONDITION IF NOT ACCEPTED CHANGE THE FORMULA TO K>=73.6(SSD)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Criteria must be as per the formula[/TD]
[/TR]
</tbody>[/TABLE]
Can i get hep with this formula

 

[JazzSP8]

Re: help me with if condition

Assuming your Data is as A1:D2 then in E2 possibly;

=IF(AND(D2>=A2,D2>=B2,D2>=C2),D2,A2)

Is that what you wanted? The 'OR' in your pseudo formula confused me a little.

 

[JazzSP8]

Re: help me with if condition

Actually, looking at it again, this may be what you wanted?

=IF(OR(AND(D2>=A2,D2>=C2),D2>=B2),D2,A2)