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