If month is Ferbuary or June then return a value

[NPSHELP]

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!

 

[FormR]

Hi, how about.

=IF(OR(MONTH(A1)={2,6}),A2,0)

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(OR(MONTH(A1)={1,6}),40,0)

 

[NPSHELP]

Hi & welcome to MrExcel.
How about

=IF(OR(MONTH(A1)={1,6}),40,0)

Spot on! That got it. Thanks for the super fast answers

 

[Fluff]

Glad we could help & thanks for the feedback.