IF Statements with two different Columns

Breelyn Brown

Hello,

I am trying to write a formula to state if this date is greater than XX, and a different Column = 2, then give me a 1, if not then 0 but I can not get it work.

=IF([Install Date]@row > DATE(2022, 9, 23), [Mashgin Qty]@row = 2, "1", "0"))

Breelyn Brown

Ryan Sides

You'll want to use an AND function.

=IF(AND([Install Date]@row > DATE(2022, 9, 23), [Mashgin Qty]@row = 2), "1", "0")