Hi,

You could use

=IF(F8,F8-F7+J8,"")


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"MrJim005" wrote:

Hi
I want a cell to display nothing if there is no data in a certain cell..

4100 - 4200 + 99 = -1 / if nothing is in the cell for 4100 then the sum
returned should be nothing

=F8-F7+J8 - if nothing is in F8 the cell should display nothing.

Thank
You