G

#### Guest

calculate a mortgage monthly payment based on input from previous columns

that collect loan amount, interest rate, and terms. Everything works fine in

the "Pmt" function. I'm using this function to collect the montly payment

for up to 3 different loans.

Here's the issue. I may not always have 3 loans. I may only have one most

of the time. So if the user left LOAN AMOUNT blank, INTEREST blank, and

PAYMENT TERMS blank for the other 2 loans, how can I keep the "Pmt" function

from reading #Error?

What I'm trying to do is calculate the total of all monthly payments. So my

formula reads...

=[1st Month Payment]+[2nd Month Payment]+[3rd Month Payment]

..... where each Payment uses the "Pmt" function.

When I have calculated values for all 3, the formula works great. However,

if I only have 1 loan, it bombs and read #Error, because my other 2 loans

read #Error.

Here's a sample of what the form looks like right now to help simplify things:

Mort: Amount: Interest: Terms: Monthly Payment:

=========================================

#1 $167,750 4.5% 360 $846.79

#2

#Error

#3

#Error

=========================================

Total $167,750 #Error

#2, and #3 read #Error because I have no data in the previous columns. How

can I fix that? Even if I type zeroes, the formula still reads #Error. If I

fix this to be "null" if nothing is entered in the previous columns, it might

help.

In short, I need to either fix the "Pmt" function to read zero if nothing is

entered, or I need to somehow figure out a way for my TOTAL calculation to

ignore #Error values. Can either of these be done?

Thanks, and sorry for the long message. It was the only way to illustrate

my issue. Happy Holidays.

Frank