| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide #div/0
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hide #div/0
nothing is working
Hi. It looks like you do not have a closing ")" for IsError ...ISERROR (PMT(E6/12,F6,E4) Should be something like: ISERROR(PMT(E6/12,F6,E4)) = = = = = HTH Dana DeLouis 1/9/2010 10:36 PM, bobmuse wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hide #div/0
=IF(ISERROR(PMT(F5/12,G5,F3)),"",PMT(F5/12,G5,F3))
Gord Dibben MS Excel MVP On Sat, 9 Jan 2010 19:36:01 -0800, bobmuse wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
| How do I hide hide #REF! in Excel | Excel Discussion (Misc queries) | |||
| hide code does not hide | Excel Discussion (Misc queries) | |||
| Hide Unhide Hide again | New Users to Excel | |||
| How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
Linear Mode
