hide #div/0 - 43427

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?
0
Utf
1/10/2010 3:36:01 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
1493 Views

Similar Articles

[PageSpeed] 57

 > 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?

0
Dana
1/10/2010 3:52:48 AM
=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
<bobmuse@discussions.microsoft.com> 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?

0
Gord
1/10/2010 4:48:46 PM
Reply:

Similar Artilces:

Attend a FREE CRM 3.0 Seminar
Attend a FREE HiTech Institute Microsoft Dynamics Seminar on CRM, Axapta and BizTalk. HiTech Institute is presenting Microsoft Dynamics ERP and Business Connectivity software seminars at our downtown Toronto office - 2 Bloor Street East, Suite 2103. Our in house master certified experts will guide you through what you need to know to take advantage of Microsoft CRM - Client Relationship Management, Axapta - ERP and BizTalk - connectivity. In a few short hours we hope your tour will give you the know how to take advantage of a lot of the great features in these packages. You owe it to yoursel...

create opportunity product using workflow CRM 4.0
Is there a way to populate opportunity product when a new opportunity is created using workflow functionality. I need to add all the services that are related to the opportunity/Customer pricelist. ...

CRM 3.0 for Outlook compatibilty with Skype?
After installing and using Skype, my CRM toolbar vanish in grey mode in Outlook. Adds In were not working. And I could not get the darn thing to reappear. After several tests, I uninstall Skype out of desperation. My CRM reappear and stays on. I reinstalled Skype, uses it: same disappearing act occurs. Does any one have the same problem? How did you solve it? We are using CRM 3.0, Outlook 2003 and Skype. My sales reps are driving nuts: they need all theses applications. We had same problem. Now it is gone. I don't know if medicin was Office 2007 and rollup 2 over v3c CRM client...

SPI Solution Selling Template for CRM 4.0
Is there a similar SP Solution Selling Template for CRM 4.0 that was available for CRM 3.0? I need to set up a new sales process in CRM 4.0 and be able to display sates stages and tasks as well as users to skip stages and task in the sales process. Appreciate any help. ...

CRM 4.0 Email Router: This message has not yet been submitted for delivery
Hi All, I know that there is other thread about this, but the thread is closed without solution. I have configured user setting to send out the email using email router. The email router has been configured properly. But, it seems that it takes forever to get the email sent out. When the email activity is opened, there's a message: "This message has not yet been submitted for delivery". But, when I restart the CRM Email Router (Windows Service), the email is sent immediately, and subsequently, the message in email activity dissapear. Is it necessary to restart the CRM Email Route...

Default appointment status CRM Mobile 3.0
Been using CRM 3.0 for a few months now, and started using Mobile last week. I have noticed that all new appointments created in CRM Mobile default to "Free" status. In our organisation, where appointments aren't put in the system until they're confirmed, this will potentially cause issues with employee scheduling as the Outlook calendar is relied upon to track employee movements. Have tried adding the appointment status field through Mobile Customization, however this only gives the free and tentative options, despite the customiser indicating that the others should be av...

CRM 4.0 Advanced Find
Hi All, I'm having some trouble upgrading some functionality used in CRM 3.0 to CRM 4.0 Basically the model is.. a contact has a group of interests these interests exist in a seperate entity the contact is connected to an interest through a link entity (contact- interest). (basically making a many to many) The user can then use an advanced find to search for all contacts with a certain set of interests. For example: Contact 1 has interest A and interest B Contact 2 has interest A The user wants to find contacts with interest A and interest B An advanced find with contacts with conta...

Test Batch Count = 0 when importing to CRM 3.0 with SQL 2005
I'm trying to migrate some accounts (about 300) and contacts to CRM 3.0 using SQL 2005 on SBE 2003. The source is a .xls and I have mapped everything using SSIS including the Owners which i mapped later using the wizard provided in DMF, the problem is that cdf_<entity>_info tables are not being populated at all, i think that triggers are not being used by SSIS. Consenquently, when i launch the final wizard, everything results in "Test Batch Count = 0". I have read that when using DTS, you had to disable Fast Load in order to use the triggers, but is there something simila...

Unable to make Formula Hide in Cell
Hello Everyone - OK, here's what it is: I cannot make a formula in a cell hide when th cell is de-selected. Instead of returning some sort of result, all see is the actual formula. I tried CTRL + ` but that doesn't d anything but change the width of the columns (I do not know what tha is all about, either). Thoughts? Thankx, C -- theboatdud ----------------------------------------------------------------------- theboatdude's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1024 View this thread: http://www.excelforum.com/showthread.php?threadid=31891...

Hiding or filtering ?
I have a sheet that represent records each record has a code such as: K,K1,K2 1, 2, 3, ... 12, 12A, 12B The sheet has about 800 lines of data records. The code is in colomn B . For simplicity reason, Is it possible that If I type one of the codes in cell C1 to see only the lines with that specific code. If I type 6a in cell C1 then I would see only line with that code. Is it better to use hiding line or filtering? This is because the data in this sheet will be used in other sheets... A VBA code that works automaticly is more preferable than cliking a button (macro). Any advice is apprici...

"Hide spelling errors in this document"
I've received a Word doc from someone that does not show the spelling errors. When I go to Tools/Options/Spelling & Grammar, I see that "Hide spelling errors in this document" is checked, but the check and the words are grayed out and I cannot uncheck it -- what gives? I want to uncheck that. Jack ...

Outlook Crashes V4.0
Outlook Testing on Two Issues 1. Memory Usage. We have outlook client v4.0 installed on 4 machines which all seem to have large usage memory issues. I've done some testing on On-Line/Offline Rebooting and each of the same. It would appear that the large memory usage in Outlook and SQL Server occurs when Outlook taken Offline and then rebooted then taken back online. I’ve seen outlook memory usage jump from 80MB to 210MB after sending 1 email NOT CRM linked, and SQL hitting 240MB. Whereas going online and rebooting (otherwise memory jumps and keeps rising) I have 80MB Outlook 120MB...

Can't "Hide Header Information" in Task View Reading Pane
I'm running Outlook 2003, SP3. In the Task View Reading Pane, the header information takes up a lot of screen space. I'd like to get rid of it. I have found two dialogs with a checkbox for "Hide Header Information", but checking and unchecking that box has no effect. It appears to be a bug. Any suggestions? ...

Would you tell me how i can easily print a document In VC++6.0
Hi all, Now i need to write a program to print something. But so far i only know it's not easy with VC, and only know I have to caculate row-spacing, set the numbers of line per page by myself and use OnDraw() fucntion. From my friends I know print is not a very difficult thing in other Langauge, i'm here just want to know whether it have the easy way for VC too. Thanks for your kindness and help, Geoff ...

Installing CRM 3.0 02-01-06
Hi all, i have been trying to install CRM 3.0 on a new SBS installation with SQL 2005 installed, and have the following problem: When installing it asks me to select the SQL server, but my actual server does not appear on the drop down list, but two workstaions do. The SQL server icon is in the sys tray, & is up and running. Any ideas?? just try typing the name of the server in, Andy. The enumeration of all the SQL servers doesn't always work. Dave "Andy King" <AndyKing@discussions.microsoft.com> wrote in message news:D38CD239-B705-4E2E-B91F-DC7579FCD2FF@mic...

Some more simple CRM 3.0 Questions
- When e-mail is sent through CRM, since it doesn't sync with Outlook (i.e. sent folders), how do I force users to ONLY send e-mail through CRM so that all messages are tracked? The dilemma is that we want all messages tracked through CRM. - Is there a way to be automatically notified of any CRM patches? What about through WSUS? You might create a workflow rule that fires whenever an e-mail is created. -- Larry Lentz [CRM MVP] MCSE+I, MCSE W2K, MCDBA, MCSA Messaging Lentz Computer Services Microsoft Small Business Specialist San Antonio, Texas Larry@LentzComputer.net www.LentzCompu...

Mirgrate RMS2.0 to POS2009 How to ?
Has any one been able to migrate RMS 2.0 data base 2.1 to POS 2009 or restore from back up ? Theres a tool from MSFT you will need or better yet Retail Realm has a tool to do this as well that works much better and is easier. -- Maurice Gordon Maurice@americanretailsupply.com Sales/Support 1-800-426-5708 XT 1307 "AL" <AL@discussions.microsoft.com> wrote in message news:8AB7806D-9CFE-4A81-8016-72CAE87E5853@microsoft.com... > Has any one been able to migrate RMS 2.0 data base 2.1 to POS 2009 or > restore > from back up ? ...

GP 10.0, reference fields
In posting Journal entries, you are required to enter a reference description for the entry. However, that reference does not follow down to each line and does not print on the Trial balance report. Is there a setting to have the reference description link to each line posted in the general ledger and print on the trial balance?? -- accountant Out of the box it does not exist, but it could be customized using VBA and modifier. Regards, -- Mohammad R. Daoud MVP, MCP, MCBMSP, MCTS, MCBMSS Mob: +962 - 79 -999 65 85 Great Package For Business Solutions daoudm@greatpbs.com http://www.gre...

Setting up SSL in 3.0
Well, we finally got 3.0 into production, and it looks OK. (Probably because 1.2 reduced our expectations :) We installed without SSL enabled, but now I'd like to make it available over the internet, but I can't figure out how to enable SSL. I have created a certificate, set up IIS and done everything that I usually do, but I get an error "The page cannot be displayed. The page you are looking for is currently unavailable... etc." when I try to access https://crm. I really don't want to uninstall and reinstall. I reckon that I need to update some config file but I d...

RMS v2.0
I know this was released already, but does anyone know when it will actually be shipped or when we will receive it? Seconded - Anyone actually recv it? Any (end user) actually get anything official from MS about it at all? "Mark" wrote: > I know this was released already, but does anyone know when it will actually > be shipped or when we will receive it? We have received a new features press release and a readiness upgrade clinic sheet from our partner. Previous posts suggested a 2/12 or so release date. "Tad L" <TadL@discussions.microsoft.com> wrote ...

return blank instead of 0
In my spreadsheet, I am trying to get data from another Excel file. eg. ='[2004 Distribution Survey Data_Final.xls]2. Expenses- Cost Center'!$B$87 When the input file contains a blank cell, I am getting a "0" intead of a blank. I would like to get a blank if the cell has no data. Is there an easy way to do this? I don't want to change all my formulas to =If(isblank(...),"", ...) There are too many formulas to change. Thanks a lot for any help! Wei Hi you could try tools / options / view and untick zero values Cheers JulieD "Wei" <anon...

Fax Integration in CRM 4.0
Hello, CRM 3.0 Small Business Edition had Fax Integration with Windows Shared Fax Services. Is it available in any edition of CRM 4.0? I can't find a single word about it in any guide. Thank you in advance, Jevgenij ...

how to open VC++ 6.0 projects in VC++.NET
Hi all, i am trying to open the VC 6 projects in VC .NET IDE. But I am getting lots of compiler error. I heard VC 7 supports backward comaptability. Can any one tell me how can i acces code in vc++ 6.0 when i'm working in vc++.NET Regards BHargav bhag wrote: > Hi all, > i am trying to open the VC 6 projects in VC .NET IDE. But I am getting > lots > of compiler error. > I heard VC 7 supports backward comaptability. > Can any one tell me how can i acces code in vc++ 6.0 when i'm working > in vc++.NET > Regards > BHargav > Bhag: If you are getting comp...

Dynamics CRM 4.0: Virtual PC Image (RC0 Release)-Last Modified 18/11/2007
https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID={78370CDE-2EA2-439C-8A03-3C690992D044}&NRORIGINALURL=/partnersource/products/mscrm/newsevents/news/CRM4VPCImageRC0Release&NRCACHEHINT=Guest&wa=wsignin1.0 -- Aamir http://danishmscrm.blogspot.com/ ...

#DIV/0! Error
Hi I get an error (#DIV/0!) when I divide one cell by the other and there are no entries in the cells. How can i get the folrmula to surpress the error (show a blank cell) when there are no entries in the cells that the formula refers to? Could you please provide an example Thanks John =IF(B1=0,"",A1/B1) -- HTH Bob Phillips "Joohn Calder" <JoohnCalder@discussions.microsoft.com> wrote in message news:4A736933-8B5E-4D25-A67F-AADE56803802@microsoft.com... > Hi > > I get an error (#DIV/0!) when I divide one cell by the other and there are > no ent...