Formula using =IF(MONTH)

[davids4500]

The formula i am using is:- =IF(MONTH(C4)=1,Superannuation[SUM],"",IF(MONTH(C4)=4,Superannuation[SUM],"", IF(MONTH(C4)=7,Superannuation[SUM],"",IF(MONTH(C4)=10,Superannuation[SUM],""))).
when I use the formula =IF(MONTH(C4)=1,Superannuation[SUM],"") it has a correct result. When i add to it as above, it comes back with (You have entered too many arguments with this function).
C4 is the month in mmmm-yyyy format. So i only want the result posted if it corresponds to the 1st month, 4th month, 7th month or 10th month.
Looking forward to your help
Much appreciated
David

 

[Phuoc]

Try this:

=IF(OR(MONTH(C4)={1,4,7,10}),Superannuation[SUM],"",

Or:

=IF(MOD(MONTH(C4),3)=1,Superannuation[SUM],"",

 

[StephenCrump]

If you nest the IFs, you only need the value_if_false ("") once, at the end:

=IF(MONTH(C4)=1,Superannuation[Sum],IF(MONTH(C4)=4,Superannuation[Sum],IF(MONTH(C4)=7,Superannuation[Sum],IF(MONTH(C4)=10,Superannuation[Sum],""))))

You could simplify to:

=IF(MOD(MONTH(C4),3)=1,Superannuation[Sum],"")

 

[davids4500]

Try this:

=IF(OR(MONTH(C4)={1,4,7,10}),Superannuation[SUM],"",

Or:

=IF(MOD(MONTH(C4),3)=1,Superannuation[SUM],"",

well done and thank you
Much appreciated
David

 

[davids4500]

If you nest the IFs, you only need the value_if_false ("") once, at the end:

=IF(MONTH(C4)=1,Superannuation[Sum],IF(MONTH(C4)=4,Superannuation[Sum],IF(MONTH(C4)=7,Superannuation[Sum],IF(MONTH(C4)=10,Superannuation[Sum],""))))

You could simplify to:

=IF(MOD(MONTH(C4),3)=1,Superannuation[Sum],"")

Yes works great.

Much appreciated
David