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