If condition

bhandari · Nov 18, 2018

SSD	PSD	HSD	K	FORMULA
73.6	134	41	118	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)
				Criteria must be as per the formula

Can i get hep with this formula

JazzSP8 · Nov 19, 2018

Re: help me with if condition

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

Code:

=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 · Nov 19, 2018

Re: help me with if condition

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

Code:

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