Help Got me stuck

[Dave666]

=AND(K4,L4<0,"", SUM(K4-L4))
All I get is ' value ' message

 

[jtakw]

Hi,

You're going to have to explain what you're trying to do, your formula, as it is, makes no sense.

 

[Dave666]

If the 2 cells are empty leave blank otherwise deduct the second from the first.
Trying to make an accounting page.

 

[jtakw]

Try this, are you also wanting to check if 1 of the cells is negative? Since in your OP, you were testing "K4<0"

Excel 2010
	C
1
Sheet18

Cell Formulas
Range	Formula
C1	=IF(AND(K4="",L4=""),"",K4-L4)

 

[Dave666]

If and
thanks

 

[jtakw]

You're welcome, welcome to the forum.

 

[Dave666]

Thanks. Only trying to teach myself. Sometimes it's the simple things that throw me.