•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Using AND and OR within the same formula - Part 2
Our take
In this discussion, we delve into the challenge of combining multiple conditions using the AND and OR functions within a single formula. Specifically, we explore how to structure a formula that meets two scenarios: when A equals 0 and B is one of 0, 1, or 2, or when A equals 1 and B is either 0 or 1. This inquiry builds on previous insights shared by the community, and your expertise is invaluable in crafting a solution that simplifies data analysis.
Thanks all for helping with a similar query earlier. I have another condition for the same dataset that I’m analysing. I would like the following:
A = 0
AND
B = one of 0, 1, 2
OR
A=1
AND
B = 0 or 1
Is it possible combine both of these into a single formula? Thank you
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need more than 3 outputsI’m looking for the cleanest way to add this. Having it feed from another sheet is open to consideration as well. Basically what I’m looking for is an IF OR formula for 3 conditions and 3 outcomes. If cell A1 is A the B1 will display as Yes If Cell A1 is B then B1 will display as No If cell A1 is C then B2 will display as maybe Any suggestions? submitted by /u/Amazing_Complaint_13 [link] [comments]
- 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]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#AI formula generation techniques#rows.com#formula generator#Excel compatibility#large dataset processing#financial modeling with spreadsheets#Excel alternatives#AND#OR#formula#dataset#A#B#condition#query#combine#analysis