If Formula help needed

[mcampbell4]

I'm trying to build an IF formula in excel. Depending on whether the primary cell (G2) has a 'Yes' or a 'No' our salesmen cost sheet will calculate a different commission.

The following formula is not working, but I think it's close; =IF(G2="yes",K19*.35,""),IF(G2="No",K19*.20,"")

I'm trying to build one formula based on whether a 'Yes' or 'No' is input into cell G2.

Thanks in advance for your help!

[AliGW]

Try this:

=IF(G2="yes",K19*.35,IF(G2="No",K19*.20,""))

[Sam Capricci]

here is the reason it fails
=IF(G2="yes",K19*.35,"") at this point you've finished the formula so if G2 equals yes then you'll get K19*35 but if it is no then it will return the blank and this portion never has to work...
IF(G2="No",K19*.20,"")
When you write an IF formula you are saying that if this condition is true do this, otherwise do that (the "do this if fail") if you combine more than one IF then where the "do this if fail" would be is where you begin your next IF statement.
That is why what Ali gave you should work.