Dont show #VALUE if cell in formula is empty

[ipbr21054]

I use the simple formula below but sometimes the cell in question doesnt yet have a value.
Because of this the cell that the formula is in shows #VALUE


Please advise how it is written so the cell shows £0.00

The formula in use is as follows.

=SUM(J2-N2)

 

[saboh12617]

Hello,
You can use ISERROR Function
Also since you do a simple subtraction you do not need SUM.

=IF(ISERROR(J2-N2), 0, J2-N2)

 

[etaf]

if its blank it should use the blank cell as zero

you could use iferror()

=IFERROR(SUM(J2-N2),"")
or
=IFERROR(SUM(J2-N2),0)

but maybe worth knowing whats in the cells to cause the issue

 

[ipbr21054]

Thanks i used the advice in post 4

The reason #VALUE is shown is that its on a sheet that im not currentlty working on.
Its in place for when the active sheet is full then the sheet in question will be worked on.

Thanks