If condition

[avisoft20]

Dear All Experts,
I hope all is well,

I am working on the condition but have not received the proper result. Below is the table , condition is
1. Column A has a duplicate value
2. Required formula in H column (if column G1 is greater column F1 then its give result "ok" and also if G2 is greater than F1 its show "ok")

A	B	C	D	E	F	G	H	I
Material	Description	MaterialUnit	BOMMaterial	BOM MatDescription	Stock	Monthly Req. GZ01	Calculation	Status
2002902	IG BSMT DUBAR 1kg ctn	CAR	2205170	POLY IG DUBAR 1KG	2,347	2,077	270 (=F3-G3)	ok
2002974	IG BSMT DUBAR 1kg PP	BAG	2205170	POLY IG DUBAR 1KG	2,347	1,209	(939) =((F3-G3)-G4)	no

Required your help
Thinkin you
avisoft20

 

[Ramadan2512]

I think that there is something wrong in your question because of F1 is sharing the second function unless if you mean both are more than F1
try this

=IF(G1>F1,"OK",IF(G2>F1,"OK",""))
or this if you mean both to be more than F1
=IF(AND(G1>F1,G2>F1),"OK","")

 

[Scott Huish]

I think that there is something wrong in your question because of F1 is sharing the second function unless if you mean both are more than F1
try this

=IF(G1>F1,"OK",IF(G2>F1,"OK",""))
or this if you mean both to be more than F1
=IF(AND(G1>F1,G2>F1),"OK","")

If it's the first one I would use OR instead of nesting IFs
=IF(OR(G1>F1,G2>F1),"OK","")

 

[Alex Blakenburg]

Your words referencing row 2 don't line up with your example, which seems to indicate that the heading row is row 2 and the first data line is row 3.
I think you might need something like this but I don't know how that would work if you added more data to the table and the BOM's aren't grouped together and in order.

Book1
	A	B	C	D	E	F	G	H	I
1
2	Material	Description	MaterialUnit	BOMMaterial	BOM MatDescription	Stock	Monthly Req. GZ01	Calculation	Status
3	2002902	IG BSMT DUBAR 1kg ctn	CAR	2205170	POLY IG DUBAR 1KG	2,347	2,077	270	ok
4	2002974	IG BSMT DUBAR 1kg PP	BAG	2205170	POLY IG DUBAR 1KG	2,347	1,209	(939)	no
Sheet1

Cell Formulas
Range	Formula
H3:H4	H3	=F3-G3-IF(D3=D2,G2,0)
I3:I4	I3	=IF(H3>=0,"ok","no")