ExcelBanter - Ignore #N/A in a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Ignore #N/A in a formula (https://www.excelbanter.com/excel-discussion-misc-queries/130600-ignore-n-formula.html)

[email protected]

Ignore #N/A in a formula

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

Ibrahim

Ignore #N/A in a formula

Archana,

you can use =IF(A2=#N/A,"",((A2*A3)+(B2*B3)+(C2*C3))/A1))

" wrote:

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

All times are GMT +1. The time now is 07:47 AM.