NAGARAJAN_EXCEL
New Member
- Joined
- Sep 29, 2020
- Messages
- 5
- Office Version
- 2019
- Platform
- Windows
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