Add to cells then find %

[jolthof]

I'm looking for a formula to return the percentage of YES in C1. I only know how to do this when adding an additional column to get the total of A1 and B1.

This should be so easy I'm embarrassed to ask.

A1 is the total number of YES from another sheet
B1 is the total number of NO from another sheet
C1 I need a formula to return the percentage of YES

[JohnTopley]

Try

in C1

=(A1)/(A1+B1)

format cell as %

[jolthof]

Thank you!!