Formula Needed

[jaybar0812]

Hello Im trying to create a formula that will only calculate the sum of base pay to performance % if there is a yes in column G or H. For instance in the performance amount cell J11 (column J) I want the formula to calculate the award amount of $38,000 * 3% as long as there is a Yes in column G11. I tired this formula but it will not work.

 

[jaybar0812]

Thank you but that still not working. The amount is coming to 12,147 when it should be 0.

Thank you but this is giving my a #SPILL error
[/QUOTE]
Thank you soooo so much! That worked!!!!!!!