HIDE #div/0

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
 
F

Fred Smith

You haven't matched the parentheses properly. Use:
IF(ISERROR (PMT(E6/12,F6,E4)),"",(PMT(E6/12,F6,E4)))

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hide #div/0 2
Excel equations 6
I need to copy a formula to a 100 cells 3
I need to hide a formula 6
Copy condtional formatting in XL2007 for Windows 1
Formula 2
Conditional formatting for time 2
Fill down formula (but changing cell value by two) 2

Top