kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 922
- Office Version
- 365
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:
Appreciate any help. Thanks
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:
Excel Formula:
=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