RANDBETWEEN WITH IF CONDITIONS

[NAGARAJAN_EXCEL]

A=RANDBETWEEN (117,151)
B=RANDBETWEEN (10.8,13.4)
C=RANDBETWEEN(D-20,D+20)
D=RANDBETWEEN(68,92)
E=C/D
F=((0.48*B*((A)/E)/1000))
G=(6700-(5*25))*F*((1/(500-25))-(1/(800-25)))*0.9

THIS FORUMULA, I have given in cells
BUT I REQUIRE
F <1.250
G>2.220
H= IF(AND(F <1.250,G>2.220),"OK","WRONG")

IS IT POSSIBLE, PLEASE GUIDE ME HOW TO DO

 

[Sulprobil]

MrExcel_RANDBETWEEN WITH IF CONDITIONS.xlsx
	A	B	C	D	E	F	G	H
1	A	B	C	D	E	F	G	Comment
2	140	11,6	76	88	0,863636364	0,902602105	4,3527182
3					F has to be at least:	0,460350655	2,22
4	Minimum F will be achieved by applying:
5	117	10,8	88	68	1,294117647	0,468680727		Ok
6
7	Maximum F is achieved by applying:
8	151	13,4	48	68	0,705882353	1,375912		Wrong
9
10	F is safely below 1.25 by applying:
11	151	13,4	52,8350208	68	0,7769856	1,2499999999999800		Ok
12
13	So the general formula could be:
14	120	11,8	98	90	1,088888889	0,624195918	3,0101292	Ok
Sheet1

Cell Formulas
Range	Formula
A2,A14	A2	=RANDBETWEEN(117,151)
B2,B14	B2	=RANDBETWEEN(108,134)/10
C2	C2	=RANDBETWEEN(D2-20,D2+20)
D2,D14	D2	=RANDBETWEEN(68,92)
E2,E14,E11,E8,E5	E2	=C2/D2
F2,F14,F11,F8,F5	F2	=0.48*B2*A2/E2/1000
G14,G2:G3	G2	=(6700-(5*25))*F2*((1/(500-25))-(1/(800-25)))*0.9
C5	C5	=D5+20
C8	C8	=D8-20
H8,H11	H8	=IF(F8<1.25,"Ok","Wrong")
C11	C11	=D11-MIN(20,D11-A11*B11*D11*0.48/1250-0.000000000001)
C14	C14	=RANDBETWEEN(D14-MIN(20,D14-A14*B14*D14*0.48/1250-0.000000000001),D14+20)
H14	H14	=IF(AND(F14<1.25,G14>2.22),"Ok","Wrong")

 

[Sulprobil]

As Joeu2004 mentioned, the ROUNDUP is necessary (here in C14):

=RANDBETWEEN(D14-ROUNDDOWN(MIN(20,D14-A14*B14*D14*0.48/1250-0.000000000001),0),D14+20)

which is

=RANDBETWEEN(MAX(D14-20,ROUNDUP(A14*B14*D14*0.48/1250+0.000000000001),0),D14+20)

 

[NAGARAJAN_EXCEL]

THANK YOU SO MUCH