If Yes, then Add question
 

I am not sure if I am phrasing this correctly or not. But I have a worksheet
I am working on that will allow me to help clients payoff debts and show
their debt to income ratio. The work sheet section has a list of the debts to
be paid off. I have four columns in this particular section. Acct. Name,
Account Bal, Mth Payment and a yes / no (Yes, count the debt in the ratio :
No don't count the debt.) The yes/no column is the trigger on whether to
include the debt in the total debt ratio or not. I don't know the formula on
how to accomplish this.

Any help would be appricaited.

Jeff

Name Balance Amount Yes / No
$1 IF(M21="yes" THEN COUNT
$1
$1

If Yes, then Add question
 

You're looking for a formula that has the following syntax:
=IF(A1="Yes",B1+C1,C1). Here I'm assuming that A1 has the yes or no, B1 has
the debt amount, if any, and C1 is the total debt ratio. If that doesn't
help make clear what you need to do, please post back.

Dave
--
Brevity is the soul of wit.


"JT" wrote:

I am not sure if I am phrasing this correctly or not. But I have a worksheet
I am working on that will allow me to help clients payoff debts and show
their debt to income ratio. The work sheet section has a list of the debts to
be paid off. I have four columns in this particular section. Acct. Name,
Account Bal, Mth Payment and a yes / no (Yes, count the debt in the ratio :
No don't count the debt.) The yes/no column is the trigger on whether to
include the debt in the total debt ratio or not. I don't know the formula on
how to accomplish this.

Any help would be appricaited.

Jeff

Name Balance Amount Yes / No
$1 IF(M21="yes" THEN COUNT
$1
$1

If Yes, then Add question
 

assuming the amount column is column L and the yes no column is column M and
the data is in rows 21 to 30 try
=sumif(M21:M30,"yes",L21:L30)
adjust as needed.

"JT" wrote:

I am not sure if I am phrasing this correctly or not. But I have a worksheet
I am working on that will allow me to help clients payoff debts and show
their debt to income ratio. The work sheet section has a list of the debts to
be paid off. I have four columns in this particular section. Acct. Name,
Account Bal, Mth Payment and a yes / no (Yes, count the debt in the ratio :
No don't count the debt.) The yes/no column is the trigger on whether to
include the debt in the total debt ratio or not. I don't know the formula on
how to accomplish this.

Any help would be appricaited.

Jeff

Name Balance Amount Yes / No
$1 IF(M21="yes" THEN COUNT
$1
$1