OK, thank you very much for your help I was able to fix every formula using
your advice, pull an all nighter but worth the time, you guys rcok!!


"Joe User" <joeu2004 wrote in message
...
"axelman" wrote:
I use fire fox [....] you should be able to download
just the loan.xlsx file

I finally fixed Firefox on my computer, and I was able to download
loan.xlsx.


"axelman" wrote elsewhe
Thanks for your help but still have same issues

The change I suggested elsewhere does indeed fix the problem that you
reported. The fix is:

=IF(COUNT(F378,D378,C378)<3, "", MAX(0, C378-D378-F378))

copied up and down the column.

But as you say, the template seems to have many other problems. I do not
wish to try to fix every design flaw in the template. That is someone
else's job.


----- original message -----

"Joe User" <joeu2004 wrote in message
...
"axelman" wrote:
I do not know why internet explorer downloads as a zip file.
I use fire fox [....] you should be able to download just
the loan.xlsx file

Yeah, I had wanted to use Firefox. But coincidentally, I had updated to
the latest revision today, and there is something wrong it (on my
computer).

I had tried to use your original URL, which ended with loan.xlsx. But
that, too, downloaded a zip file with many files.

Go figure! I don't know enough about browser technology to speculate
what the problem might be.


----- original message -----

"axelman" wrote in message
...
Yes I already did, this link lis in my webserver, I do not know why
internet explorer downloads as a zip file.

I use fire fox and --right mouse click on the download link-- then
save link as, you should be able to download just the loan.xlsx file it
is just 57 kb

Thanks in advanced for your help
"Joe User" <joeu2004 wrote in message
...
"axelman" wrote:
please download my current worksheet from
http://www.iodatamicro.com/worksheet/
[....]
Can you please take a look at the formulas
and send me your suggestions.

Much too complex a zip file for me take risk downloading to my
computer.

Can you isolate the problem in a simple worksheet?

What happened when you used the IF(COUNT...) solution that I suggested?


----- original message -----

"axelman" wrote in message
...
Hi

Here is the link again

please download my current worksheet from
http://www.iodatamicro.com/worksheet/

Just click on the download link

Can you please take a look at the formulas and send me your
suggestions.


"axelman" wrote in message
...
Hi

I've downloaded a mortgage calculator from the web, being anewbie
I'm stuck with the following issue:

When the last payment comes down to 0 or near 0 like 0.03 cents all
the formulas values return a #VALUE!, I want that the value be
displayed as 0.

In example the maximum payments are 431 monthly payments, lets say
the last payment the client made was for 378, now after that paymet I
need the value to be displayed as 0 up to row 431, because he has
finished his payments.

A formula is

if(F378+D378<C378,C378-(D378+F378),"")

EVALUATES TO------ if(""+0<C378,C378-(D378+F378),"")

THAT RETURNS----- #VALUE!

Can you help me, it would be greately appreciated