Nested IF Statement

[cspgsl]

I created a nested IF statement to return a value.

=IF($B4="DIS",IF($C4=M$2,$K4,""))

How can I get it to return a value of zero if it is false instead of the word FALSE?

I tried this but it didn't make any difference

=IF($B4="DIS",IF($C4=M$2,$K4,0))

If Stmt.xlsx
	A	B	C	D
1	SYM	TYPE	PYMT	DIV
2
3	LIF	DIV	3	3
4	AXU	DIS	4	FALSE
Sheet1

Cell Formulas
Range	Formula
D3	D3	=IF(A3="LIF",IF(B3=D1,C3,""))
D4	D4	=IF(A4="LIF",IF(B4="DIV",C4,""))

Thanks

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1	SYM	TYPE	PYMT	DIV
2
3	LIF	DIV	3	3
4	AXU	DIS	4	0
Lists

Cell Formulas
Range	Formula
D3:D4	D3	=IF(AND(A3="LIF",B3=$D$1),C3,0)

 

[cspgsl]

Thank you, that works

 

[Fluff]

You're welcome & thanks for the feedback.