Thread: HIDE #div/0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bobmuse bobmuse is offline
external usenet poster
  
Posts: 5
Default HIDE #div/0
i need to hide #div/0 when PMT(E6/12,F6,E4 equal a 0

i tried
IF(ISERROR (PMT(E6/12,F6,E4),"",(PMT(E6/12,F6,E4))
but it is not working


Reply With QuoteReply With Quote