Hi, i have a formula that needs to be simplified in excel as there's many variables and i would end up spending a lot of time on it. this is the formula = IF(AND(A1<=10,B1<=10,C1<=10,D1<=10),"126.96.36.199" IF(AND(A1>=20,B1<=10,C2<=10,D1<=10),"188.8.131.52", ,"FALSE") the same formula has more lines, in which A1 needs to meet some more numbers criteria. i've just decided to have it short to outline the basics of it. as you might have noticed, there's 3 PRINT modes: PRINT1 = 184.108.40.206 PRINT2 = 220.127.116.11 PRINT3 = FALSE in PRINT2, the A1 criteria has changed, which is why i asked that it will PRINT 18.104.22.168 if the criteria is true else, if the criteria is not true, it will PRINT false (PRINT3) THE ISSUE that i have is that this formula that i'm using will have many combinations .. about 15 combinations if not more. WONDERING if there's a way i can ease my pain in excel.
This question generated 21 answers. To proceed to the answers, click here.
This thread is current as of December 12, 2013.