Thread: remove the #n/a and make it 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
  
Posts: 747
Default remove the #n/a and make it 0
you can use =if(ISNA(your_formula),0,your_formula)



On May 13, 6:22*pm, mahmoud moustafa <mahmoud
wrote:
Hi
How do i remove the #n/a and make it 0

Reply With QuoteReply With Quote