Add IFERROR to a long Formula

[kumara_faith]

Hi,

I have the following formula which I am trying to add an IFERROR formula that would return blank if the result is an error. However, I am not sure how to accomplish this as when I add IFERROR before the formula at the beginning and add a comma at the end, I cant get the formula to work:

=IFERROR(H11*H9)+(I11*I9)+(J11*J9)+(K11*K9)+(L11*L9)+(M11*M9)+(N11*N9)+(O11*O9)+(P11*P9)+(Q11*Q9)+(R11*R9)+(S11*S9)+(T11*T9)+(U11)/((E11-F11-G11)*(450)),"")

Appreciate any help. Thanks

 

[kumara_faith]

Hi,

Tried below but the formula seems to be providing incorrect value:

=IFERROR(((H11*H9)+(I11*I9)+(J11*J9)+(K11*K9)+(L11*L9)+(M11*M9)+(N11*N9)+(O11*O9)+(P11*P9)+(Q11*Q9)+(R11*R9)+(S11*S9)+(T11*T9)+(U11))/((E11-F11-G11)*(450)),"")

 

[kweaver]

I think you need 1 more "(" after "IFERROR"

 

[kumara_faith]

Thank you kweaver. That worked and sorry for the inconvenience.

 

[jtakw]

Hi,

Your formula can be shorten a bit using SUMPRODUCT like below:

=IFERROR((SUMPRODUCT((H9:T9)*(H11:T11))+U11)/((E11-F11-G11)*450),"")