On Feb 13, 10:00 pm, 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

if(isna(formula), "", formula)

Cheers,
Jason Lepack