=IF(OR(H10="",(I10="")),"",H10+I10)

Will show blank if either cell has no value.


Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 08:03:01 -0700, Killer
wrote:

Example:

H10 = 12
I10 = Blank

Result should be left blank

If

H10 = 12
I10 = 8

Result should be 20

Thanks!