If two Columns have Data enter the Amount Question!
Apologies, gave you a formula for zero not for blanks that's why is important
listening to The Rain myself. Thanks Gord you became the rain.
--
Can''''t hear the Rain ?
Then listen to it.
"Gord Dibben" wrote:
=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!
|