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

1. ## 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. ## 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.

3. ## 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
•