excel vba - cell value sum

[chief]

is it possible to set something up so that you get eg. K19 being the su
of B19*D19, however the sum value in K19 only shows up when there ar
values in B19 and D19? I don't want to have =SUM(B19*D19) in the K1
cell and copy and paste the formula into the cells below it. If ther
is no value in B19 and D19, it will produce a 0 in the cell. That'
not what I am looking for. I want to have that formula ready to su
whenever numbers are added into the B19 and D19 cells, and not have an
values in K19 until the others have value

 

[Paul B]

Chief, how about a formula that will return "' if B19 or D19 are blank?
like this
=IF(OR(ISBLANK(B19),ISBLANK(D19)),"",B19*D19)


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[JE McGimpsey]

One way:

=IF(COUNT(B19,D19)=2,B19*D19,"")

Note that SUM() is unnecessary since you're using the multiplication
operator.

 

[chief]

thanks alo