I currently have an issue with a statistics sheet for a sports team. If I have a total amount of practices, with the number of days missed subtracted for each player. How do I turn that into a percentage of their attendance?

  • pls share a copy of your sheet – user0 Apr 28 '19 at 15:38

=TEXT(D2/B2, "0.00%")


which can also be:

=TEXT((B3-C3)/B3, "0.00%")


or in one go:



| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.