Formula returns #Value! empty cell value

I have a cell with the following formula:

=((F1*I10)+(F2*I12)+(F3*I13))/F7

Because some of the cell values are empty, the computed cell value winds up being #VALUE!. In SQL I use a function called Coalesce. Is there something I can use in Excel that would change the value to 0 just for the formula?
Thanks.

Originally Posted by ingineu

I have a cell with the following formula:

=((F1*I10)+(F2*I12)+(F3*I13))/F7

Because some of the cell values are empty, the computed cell value winds up being #VALUE!. In SQL I use a function called Coalesce. Is there something I can use in Excel that would change the value to 0 just for the formula?
Thanks.

Try

=IF(ISERROR(((F1*I10)+(F2*I12)+(F3*I13))/F7),0,((F1*I10)+(F2*I12)+(F3*I13))/F7)

That would give me 0 even if some of the values computed correctly, is that right?

eg. =((F1*I10)+(F2*I12)+(F3*I13))/F7

I would like F1*I10 to compute, if both values exist, same goes for the other 2 bracketed computes

Does this mean I need to wrap an IF stmt around all 3? There's no function available that sets the value to zero, if it's blank?

Decided to use the N function:

eg. =(N(F1)*N(I10))+.... etc.

Originally Posted by ingineu

Decided to use the N function:

eg. =(N(F1)*N(I10))+.... etc.

Ok - and thanks for the response.