IF cells are empty

  • Thread starter Thread starter RayD
  • Start date Start date
R

RayD

Hello everyone,

I have the need to blank a cell (J8) if "either" of the two cells to it's
left (H8 and I8) are empty. I have tried to expand off of the following but
with no success.

=IF(H8:I8=0,"",SUM(H8-I8))

Can anyone shed some light on this?

Thanks
...Ray

...Ray
 
Thanks Very much Aladin



=IF(COUNTBLANK(H8:I8),"",H8-I8)

RayD said:
Hello everyone,

I have the need to blank a cell (J8) if "either" of the two cells to it's
left (H8 and I8) are empty. I have tried to expand off of the following but
with no success.

=IF(H8:I8=0,"",SUM(H8-I8))

Can anyone shed some light on this?

Thanks
..Ray

..Ray
Click to expand...

...Ray
Click to expand...
 
Back
Top