Ignore #N/A in a formula

[archanapatelwhite]

Hi I have the following formula

=((A2*A3)+(B2*B3)+(C2*C3))/A1

how can I get the result ignoring #N/A for example if A2 = #N/A

Please help

Thanks
Archana

 

[JE McGimpsey]

In general, you'd be far better off to eliminate the #N/A from your
input cell.

However, you don't say what you want to happen - by "ignore", do you
mean treat as zero? Or something else?

Perhaps something like

=SUM(IF(ISNA(A2*A3),,A2*A3), IF(ISNA(B2*B3),,B2*B3),
IF(ISNA(C2*C3),,C2*C3))/A1

 

[T. Valko]

Will you only have #N/A's in row 2?

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=SUM(IF(ISNUMBER(A2:C2),A2:C2*A3:C3))/A1

Biff

 

[Guest]

This formula ignored all the #N/A either in Row 2 or Row 3 or both

=SUM(IF((ISNUMBER(A2:C2))*(ISNUMBER(A3:C3)),A2:C2*A3:C3))/A1