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