I am putting together a calculation that would involve using an IF formula.
In sheet 1, cell C5, I want someone to put "Yes" or "No" into the cell. If
they write "Yes" I would like the percentage in cell C6 to calculate into a
cell into Sheet 2. If the answer is "No" I would like the calculation to
equal zero in Sheet 2.

How would I do that calculation?

Thank you for your help!