I'm struggling to find the right formula for this so appreciate any help.
I have a monthly budget document which details all my outgoings for the current month. I have a certain bill though that only goes out in February or June. So ideally, I'd like to have a formula which is:
If TODAY is February or June, show £40. If today is NOT February or June, show £0.
Today is A1, £ to be returned will go in A2.
I'm sure it's simple but I'm just not able to return the right value.
Thanks!
I have a monthly budget document which details all my outgoings for the current month. I have a certain bill though that only goes out in February or June. So ideally, I'd like to have a formula which is:
If TODAY is February or June, show £40. If today is NOT February or June, show £0.
Today is A1, £ to be returned will go in A2.
I'm sure it's simple but I'm just not able to return the right value.
Thanks!