Nested if formula in excel

[manoj_arsul]

Dear All,

Please guide me to find if formula below conditions

Formula in Coloumn P:
Check column D if D is Low then check C & O is less than 24 or not if Yes then print "Met"
Check column D if D is Medium then check C & O is less than 12 or not if Yes then print "Met"
Check column D if D is High then check C & O is less than 8 or not if Yes then print "Met"
Check column D if D is Critical then check C & O is less than 4 or not if Yes then print "Met"
If from above any condtion not match then print "Not Met"

C D O P
10 Low 15 Met
12 Medium 10 Not Met
8 High 6 Met
3 Critical 4 Met

Thanks & Advance !

 

[Snakehips]

Maybe like below. However, your required result does not match your described conditions?

Book1
	C	D	E	F	G	H	I	J	K	L	M	N	O	P
2	10	Low											15	NotMet
3	12	Medium											10	NotMet
4	8	High											6	NotMet
5	3	Critical											4	NotMet
6	3	Critical											3	Met
Sheet8

Cell Formulas
Range	Formula
P2:P6	P2	=IF(OR(AND(D2="Low",C2=24,O2<24),AND(D2="Medium",C2<12,O2<12),AND(D2="High",C2<8,O2<8),AND(D2="Critical",C2<4,O2<4)),"Met","NotMet")

 

[manoj_arsul]

@Snakehips thank you