Only IF Formula

[daneagle22]

Is there a formula that will only calculate a number, if another variable is a certain number?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Example: C2 is a dropdown that only lists "sold", "Demo", "no show".<o></o>
column D is the formula =if(c2="sold",1,if(c2="no_sale",1,if(c2="No_Demo",0)))<o></o>
<o></o>
Column I lists all the different sales lead types, and column J shows the value for each lead type.. ie: Internet 5, walk in 10,etc.<o></o>
<o></o>
I am trying to make only the values in column J appear if "sold" is in column C, which is a 1 in column D…. The problem is I also have a “1” in column D for “no_sale” as the employee still gets credit for a demo.<o></o>

 

[texasalynn]

so why not make your formula for column J
=if(c2="sold","your answer here","")