IF cells are empty

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
 
R

RayD

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statements 4
More than one IF Statement 4
help reducing this long nested functuion? 3
IF clause for a range of cells 3
AVG or Return 1 value from either of 2 cells if one is blank 8
Issue with numbers and Time 10
Multiple If Statements 3
Setting a cell's formula with VBA 4

Top