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