Hi,
is there a way to make a formula that multiplies 3 cells and ignores if one of the cells is empty?
Here is a short example of the problem:
=sum(a1*b1*c1) works, but if b1 is empty it returns 0, and that is how it should work, but I need to have it so that if one of those cells is empty, it ignores it and multiplies those only that have a value?
Thanks,
-F
Bookmarks