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

Reply With QuoteReply With Quote