How do I amend my IF AND statement to correctly show payments made or not?
I’ve been trying to set up a formula to show if someone has paid their membership fees. They can either pay yearly or monthly. The yearly formula seems to be working but the monthly formula seems to not work. Basically, I want it to show – if the month referenced is either the current month or a later month – if the person named for that row has paid for that month. If possible, I also want to show if someone has said they’ve paid but the payment isn’t showing in the bank.