IF with multiple condition

[Lukma]

HI Friends

i need an Assistance with a formula am little confused In, i have tried with but am getting just one result.
Appreciate good friends to help with formula and how to go about it.

IF column A=Rigs&Barge and Column B is Greater >= 70% Then Result should be Cargo Valume >70%
IF Column A=Rigs&Barges and Column B is Less than <70% Then Result should be Cargo Valume <70%
IF Column A=Complex and Column C is Greater Than 12:00 Then Result should be " Day light Complexes 12Hrs"

Appreciate any help on how to get the formula done

Thanks & Regards

 

[Legacy 143009]

Hello,

This should work:

=IF(AND(A2="Complex",C2>0.5),"Day light Complexes 12Hrs",IF(AND(A2="Rigs&Barge",B2>=0.7),"Cargo Valume >70%",IF(AND(A2="Rigs&Barge",B2<0.7),"Cargo Valume <70%")))

 

[Peter_SSs]

IF Column A=Complex and Column C is Greater Than 12:00 Then Result should be " Day light Complexes 12Hrs"

What should happen if Col A=Complex and Col C is less than or equal to 12:00?

What should happen if Col A is not Complex and not Riggs&Barges? Or is that not possible with your data?

 

[Lukma]

What should happen if Col A=Complex and Col C is less than or equal to 12:00?

What should happen if Col A is not Complex and not Riggs&Barges? Or is that not possible with your data?

Hi Peter_SS

Its Nice hearing from you Hope all is well and family

if Col A=Complex and Col C is less than or equal to 12:00? Day light Complexes <12Hrs

Regards

 

[Peter_SSs]

What should happen if Col A is not Complex and not Riggs&Barges?

No answer was given to that question but see if this does what you want.

23 11 23.xlsm
	A	B	C	D
1
2	Rigs&Barge	80%		Cargo Valume >=70%
3	Rigs&Barge	55%		Cargo Valume <70%
4
5	Other text
6	Complex		13:00	Day light Complexes 12Hrs
7	Complex		8:00	Day light Complexes <12Hrs
Lukma

Cell Formulas
Range	Formula
D2:D7	D2	=IF(A2="Rigs&Barge","Cargo Valume "&IF(B2>=0.7,">=70%","<70%"),IF(A2="Complex","Day light Complexes "&IF(C2>0.5,"12Hrs","<12Hrs"),""))

 

[Lukma]

No answer was given to that question but see if this does what you want.

23 11 23.xlsm
	A	B	C	D
1
2	Rigs&Barge	80%		Cargo Valume >=70%
3	Rigs&Barge	55%		Cargo Valume <70%
4
5	Other text
6	Complex		13:00	Day light Complexes 12Hrs
7	Complex		8:00	Day light Complexes <12Hrs
Lukma

Cell Formulas
Range	Formula
D2:D7	D2	=IF(A2="Rigs&Barge","Cargo Valume "&IF(B2>=0.7,">=70%","<70%"),IF(A2="Complex","Day light Complexes "&IF(C2>0.5,"12Hrs","<12Hrs"),""))

Hi Peter

Good day it nice hearing from you and i hope all family are doing just great, so sorry for late reply i was out from office before getting your response question

Please here is my data and example of what i need formula to get for me though it little complex for me to get around the formula any way hearing from you i believe it will definitely be resolved

Appreciate you to look into it for me anyway i will always try that you have provided.

Thanks and Regards

Book2
	A	B	C	D	E	F	G
2	Location	KPI Criteria	Deck % Loaded Per Voyage	Accumulated Hours Per Voyage	KPI Exceeded Hrs per voyage	IF Formula	Example of what I need
3	Rig Mehzem	Rigs&Barges	60%	15:0	1:0	FALSE	Cargo Volume < 70% (Not Met)
4	Rig Al Noof	Rigs&Barges	70%	12:0	0:0		Cargo Volume ≥ 70%(Met)
5	Rig SMS Essa	Rigs&Barges	40%	13:0	0:0		Cargo Volume <70%( Met)
6	Rig Yemillah	Rigs&Barges	25%	21:0	7:0		Cargo Volume ≥ 70%(Not Met)
7	Umm Lulu Complex	Complex	70%	8:38	0:0		Day Light Hrs. @Complexes ≤ 12Hrs. (Met)
8	USSC	Complex	60%	0:24	0:0		Day Light Hrs. @Complexes ≤ 12Hrs. (Met)
9	NPCC Al Maryah		0%	0:0	0:0
10	Nasr Complex	Complex	60%	16:0	4:0		Day Light Hrs. @Complexes ≥ 12Hrs. (Not Met)
11	WOW Rig Diyina	0	0%	0:0	0:0
Sheet4

Cell Formulas
Range	Formula
B3:B11	B3	=VLOOKUP(A3,$M$3:$P$17,2,0)
C3:C10	C3	=VLOOKUP(A3,$M$3:$O$17,3,0)
D3:D11	D3	=SUMIFS($P$3:$P$17,$M$3:$M$17,A3)
E3:E11	E3	=IF(B3="Rigs&Barges", IF(C3="*>=0.7*",IF(D3>TIME(20,0,0), D3-TIME(20,0,0),0),IF(D3>TIME(14,0,0), D3-TIME(14,0,0),0)),IF(AND(B3="Complex",D3>TIME(12,0,0)),D3-TIME(12,0,0),0))
C11	C11	=VLOOKUP(A11,$M$3:$O$17,2,0)

 

[Peter_SSs]

This is still unclear. If the time is exactly 12:00 should it be "Met" or "Not Met"?

Thanks for the XL2BB sample data though. That makes things much clearer and easier to copy for testing.

 

[Lukma]

View attachment 102352

This is still unclear. If the time is exactly 12:00 should it be "Met" or "Not Met"?

Thanks for the XL2BB sample data though. That makes things much clearer and easier to copy for testing.

This is still unclear. If the time is exactly 12:00 should it be "Met" or "Not Met"? If the time is less or equal to 12:00 mean "Met" and if Time is greater than 12:00 mean "Not Met"

IF Col-B=Rigs&barges and Col-C <70% and Col-D >14:00 answer should be Cargo Volume < 70% (KPI Not Met)
IF Col-B=Rigs&barges and Col-C <70% and Col-D <14:00 answer should be Cargo Volume < 70% (KPI Met)
IF Col-B=Rigs&barges and Col-C >=70% and Col-D >20:00 answer should be Cargo Volume >= 70% (KPI Not Met)
IF Col-B=Rigs&barges and Col-C <70% and Col-D <20:00 answer should be Cargo Volume < 70% (KPI Met)
IF Col-B=Complex and Col-C Col-D <=12:00 answer should be Cargo Volume < 70% (KPI Met)
IF Col-B=Complex and Col-C Col-D >12:00 answer should be Cargo Volume < 70% (KPI Not Met)

Further Please can you also look into my formula in Column E and if it is right , once i take out the wildcat "*>=0.7*"

Regards

 

[Legacy 143009]

How about:

=IF(B3="Complex",IF(D3>0.5,"Day light Complexes > 12Hrs","Day light Complexes <=12Hrs"),IF(B3="Rigs&Barges",IF(C3<0.7,"Cargo Volume <70%","Cargo Volume >=70%"),""))

 

[Peter_SSs]

I'm afraid that I am getting lost as the expected results keep changing.