ExcelBanter - HIDE #div/0

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HIDE #div/0 (https://www.excelbanter.com/excel-discussion-misc-queries/252899-hide-div-0-a.html)

bobmuse

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

Fred Smith[_4_]

HIDE #div/0

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

Regards,
Fred

"bobmuse" wrote in message
...
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

All times are GMT +1. The time now is 10:40 AM.