- Hot Topics
Excel Help Needed to Simplify Formula with Multiple Cominations with Multiple Variables
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),"184.108.40.206" IF(AND(A1>=20,B1<=10,C2<=10,D1<=10),"220.127.116.11", ,"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 = 18.104.22.168 PRINT2 = 22.214.171.124 PRINT3 = FALSE in PRINT2, the A1 criteria has changed, which is why i asked that it will PRINT 126.96.36.199 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. excel like 1 2 3 4
This question generated 21 answers. To proceed to the answers, click here.
This thread is current as of December 12, 2013.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel