formula help

  • Thread starter Thread starter Toby
  • Start date Start date
T

Toby

I am a novic at best with excel. I can add columns and simple tasks.
am trying to input a Y or N answer in a cell. If yes then cell shoul
= 0. If no, cell should read value of another cell. It would loo
like this:

A B C D
E
acct balance monthly pmt payoff new pmt
house $100000 $1,000 yes $0.00
car $ 6000 $ 500 no $ 500.00
cc #1 $ 4000 $ 50 no $ 50.00
cc #2 $ 2000 $ 100 yes $0.00

Hopefully you get the point. I have tried the following formula:
=if(D2=Y, SUM(0), (D2=N, SUM(C3)

If anyone know's how I can input the correct forlula - it would b
greatly appreciated. Getting this done could save me 10 hours a week
 
Toby

In "new pmt" column E enter =IF(D1="yes",0,C1)

Drag/copy down column E as far as you have data.

Gord Dibben XL2002
 
Your note made me look again. Typo left out a comma after Yes. CORRECTION
=if(d2="Yes"0,c2)
=if(d2="Yes,"0,c2) or
=if(d2="Yes"0,if(d2="No",c2,""))
=if(d2="Yes,"0,if(d2="No",c2,""))
Click to expand...


--
Don Guillett
SalesAid Software
(e-mail address removed)
Don Guillett said:
=if(d2="Yes"0,c2)
or
=if(d2="Yes"0,if(d2="No",c2,""))
Click to expand...
 
Gosh, Must be a BAD day?

Put the comma after the "

--
Don Guillett
SalesAid Software
(e-mail address removed)
Don Guillett said:
Your note made me look again. Typo left out a comma after Yes. CORRECTION
=if(d2="Yes"0,c2)
=if(d2="Yes,"0,c2) or
=if(d2="Yes"0,if(d2="No",c2,""))
=if(d2="Yes,"0,if(d2="No",c2,""))
Click to expand...
Click to expand...
 
Back
Top