Excel Help

[CrazyPerson]

how do i do this?

A B C D
1 good 50 5 55
2 bad 50 5 50

ie: when A is good, then B+C=D
when B is bad, the B-C=D

C has to be all positive #s


thank you

 

[HomeBrewerDude]

is this homework?

 

[CrazyPerson]

no, personal use

 

[HomeBrewerDude]

what do you mean by good and bad?

what are A B C and D?

 

[z0mb13]

put if statement in the D column.. then copy down

 

[dighn]

=if(A1 = "good", B1+C1, B1-C1)

put that in D1, copy and paste into other Ds

 

[CrazyPerson]

thanks