Numbers - multiple conditions in an if statement I am trying to do this:
IF(day(now()) &gt; 28 and day(now()) &lt; 1, A1 + B1, A2 + B2)
However this gives a syntax error. Is it not possible to have more than one operation in a condition?
I don't want to have nested IFs because the other calculations are more complicated than the example and I don't want to have to duplicate the entire thing.
IF(AND(day(now()) &gt; 28,day(now()) &lt; 1), A1 + B1, A2 + B2)

The full user guide is available here.