View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] archanapatelwhite@googlemail.com is offline
external usenet poster
 
Posts: 5
Default Ignore #N/A in 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