HIDE #div/0

  • Thread starter Thread starter bobmuse
  • Start date Start date
B

bobmuse

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
 
You haven't matched the parentheses properly. Use:
IF(ISERROR (PMT(E6/12,F6,E4)),"",(PMT(E6/12,F6,E4)))

Regards,
Fred
 
Back
Top