April 19, 2026•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

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

A=1

AND

B = 0 or 1

Is it possible combine both of these into a single formula? Thank you

Check out the full article on the original site

#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

#condition

#query

#combine

#analysis