Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Why doesn't this equation work (Excel 97)

    I took a spreadsheet that originally came from a Works wizard (I think that's were it came from, I did it some time ago) and pasted it in to Excel.
    It includes many equations similar to this one:

    =IF(AND(H4,H5,H6),-PMT((H5/12)/100,H10,H4),"")

    It seems to me that the purpose of this cell is to prevent #VALUE! from appearing in the cell until all data is entered in to H4, H5 and H6. But the #VALUE! (or DIV/0) still shows up in all the cells until all the payment data is entered

    Why aren't the cells showing up as blanks until all the data has been input?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Why doesn't this equation work (Excel 97)

    The following should work:

    <pre>=IF(AND(ISNUMBER(H4),ISNUMBER(H5),ISNUMBER(H6 )),-PMT((H5/12)/100,H10,H4),"")
    </pre>


    I can't tell without seeing the rest of your worksheet, but there may be another problem with the formula. I don't know why the formula is checking H6 for a value when H6 is not used the the PMT function.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Why doesn't this equation work (Excel 97)

    thanks, that did the trick.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •