Apple Numbers if September then?

Question

Level 2

388 points

I want to have this cell display Yes if the month in another table is September. This formula doe not work. What do I need to change?

iMac (M1, 2021)

Posted on Sep 21, 2023 8:32 PM

Reply

Answer 1

Top-ranking reply

Level 8

37,562 points

Try:

=IF(MONTH(Names & Dates::Table 1::B3)=9,"Yes","No")

More on IF here:

SG

Reply

Answer 2

Level 2

388 points

Thanks SG, the parentheses got me goofed up. It's working now.

Reply

Similar questions