Nesting multiple AND/IF/OR statements
Our take
Current formula: =IF(AND(OR(J2=$AE$3,J2=$AE$4),AC2<49,AB2<>"CRMBOOK"),$AE$5,$J$2)
Formula looks for two different values in column J, confirms AC is less than 49 and AB does not contain the text "CRMBOOK". If those conditions are true or false it retrieves the respective cells. This works perfect.
Now what I'm trying to add here is another condition, where it would look for specific values in column I, and depending on if they are present or not it would change the value of the true reference. I can't figure out the nesting and its driving me nuts...
Current:
Future: (depending on the value in column I, I want to reference a different value in column AE)
Appreciate the help!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How do you write an IF formula that changes the value based on which range, out of two ranges, the original value fell in?I'm entering number values in Column A and I want Column B (where I'm inputting the formula) to populate either a 1 or a -1 based on which range (of two ranges) the value in Column A falls within. The conditions are: If Column A value is between 1-8, then Column B will be 1. If Column A value is between 9-21, then Column B will be -1. If Column A value is outside the two ranges (below 1 or above 21), then Column B can/should say something like FALSE. The formulas I've tried so far (and which failed) are: =IF(OR(AND(A2>=1,A2<=8),1)AND(A2>=9,A2<=21),-1) =IF(AND(A2<=1,A2>=8),1)OR(AND(A2>=9,A2<=21),-1)) Thank you in advance for all of your suggestions/help. submitted by /u/LifeisSuperFun21 [link] [comments]
- How to use AND and OR conditions within the same formulaHello! I’m trying to write a formula with the following conditions: If cell A=0 AND cell B=0 or cell B=1 or cell B=2 then the outcome is TRUE It should be very simple, but I couldn’t figure it out. Thanks in advance. Edit for clarity, the below is the condition I am after: A = 0 AND B is one of 0, 1, 2 submitted by /u/pinkdaisiesss [link] [comments]