hide #div/0

B

bobmuse

i need to hide #div/0 error for the following formula
= PMT(E6/12,F6,E4) when result is =0

I used
IF(ISERROR (PMT(E6/12,F6,E4),"",(PMT(E6/12,F6,E4))
IF(ISERROR(PMT(E6/12,F6,E4),"",(PMT(E6/12,F6,E4))
IF(ISERROR PMT(E6/12,F6,E4),"",(PMT(E6/12,F6,E4)
IF(ISERROR (PMT(E6/12,F6,E4),"",(PMT(E6/12,F6,E4)))
nothing is working
what am i missing?
 
D

Dana DeLouis

nothing is working

Hi. It looks like you do not have a closing ")" for IsError
...ISERROR (PMT(E6/12,F6,E4)
Click to expand...

Should be something like:
ISERROR(PMT(E6/12,F6,E4))

= = = = =
HTH
Dana DeLouis
 

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 1
Excel equations 6
Copy condtional formatting in XL2007 for Windows 1
Formula 2
PMT calculator 8
Fill down formula (but changing cell value by two) 2
Conditional Formating Help 1
I need to hide a formula 6

Top