If two Columns have Data enter the Amount Question!
Did you look at my earlier post?
=IF(OR(H10="",(I10="")),"",H10+I10)
Will show blank if either cell is empty.
Gord Dibben MS Excel MVP
On Sun, 30 Sep 2007 13:33:05 -0700, Killer
wrote:
Thanks guys for the help but I'm still getting a result if Column I10 has no
result. There will always be data in H10 but I10 has no result.
It keeps showing result from H10!
"David Biddulph" wrote:
=IF(COUNT(H10,I10)=2,H10+I10,"")
--
David Biddulph
"Killer" wrote in message
...
Example:
H10 = 12
I10 = Blank
Result should be left blank
If
H10 = 12
I10 = 8
Result should be 20
Thanks!
|