Formula leaves the word False but would like 0

[davids4500]

I have written the formula below and if it is false, it inserts the word FALSE. I would like it to leave a '0'
Can someone help please.

=IF(AND(MONTH(B4)=12,AND(MONTH(CalculationsInfo!L47)=12,MONTH(B4)=12)),CalculationsInfo!K47, IF(AND(MONTH(B4)=1,AND(MONTH(CalculationsInfo!L48)=1,MONTH(B4)=1)),CalculationsInfo!K48,IF(AND(MONTH(B4)=2,AND(MONTH(CalculationsInfo!L49)=2,MONTH(B4)=2)),CalculationsInfo!K49,IF(AND(MONTH(B4)=3,AND(MONTH(CalculationsInfo!L50)=3,MONTH(B4)=3)),CalculationsInfo!K50,IF(OR(MONTH(B4)=4,AND(MONTH(CalculationsInfo!L51)=4,MONTH(B4)=4)),CalculationsInfo!K51,IF(AND(MONTH(B4)=5,AND(MONTH(CalculationsInfo!L52)=5,MONTH(B4)=5)),CalculationsInfo!K52,IF(AND(MONTH(B4)=6,AND(MONTH(CalculationsInfo!L53)=6,MONTH(B4)=6)),CalculationsInfo!K53,IF(AND(MONTH(B4)=7,AND(MONTH(CalculationsInfo!L54)=7,MONTH(B4)=7)),CalculationsInfo!K54,IF(AND(MONTH(B4)=8,AND(MONTH(CalculationsInfo!L55)=8,MONTH(B4)=8)),CalculationsInfo!K55,IF(AND(MONTH(B4)=9,AND(MONTH(CalculationsInfo!L56)=9,MONTH(B4)=9)),CalculationsInfo!K56, IF(AND(MONTH(B4)=10,AND(MONTH(CalculationsInfo!L57)=10,MONTH(B4)=10)),CalculationsInfo!K57, IF(AND(MONTH(B4)=11,AND(MONTH(CalculationsInfo!L58)=11,MONTH(B4)=11)),CalculationsInfo!K58))))))))))))

 

[MARK858]

@davids4500 if you click within the closing parenthesis at the end of your formula you'll get the If logical test popup where the [value_if_false] is bolded (as per the image below).
That is where you would put a 0 if you wanted that returned. You will see as you click along that there are multiple places where you need to place a 0 (or *0 or "0" depending on exactly what you need)

 

[Alex Blakenburg]

In your formula try adding ",0" without the quotes in the last line in the position shown below:

CalculationsInfo!K58,0))))))))))))

 

[offthelip]

I think your entire equation could be rewritten to be much simpler like this:

=IF(MONTH(B4)=MONTH(CalculationsInfo!L47),OFFSET(CalculationsInfo!K47,MOD(MONTH(B4),12),0))