April 19, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to use AND and OR conditions within the same formula

Hello! 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

Check out the full article on the original site

#Excel alternatives for data analysis

#AI formula generation techniques

#rows.com

#formula generator

#natural language processing for spreadsheets

#generative AI for data analysis

#Excel compatibility

#financial modeling with spreadsheets

#Excel alternatives

#formula

#AND

#OR

#conditions

#cell

#outcome

#TRUE