I'm trying to do a count of how many staff have uploaded a particular document. I have who has uploaded the document and how many staff in total, and I want to display that as a percentage on the sheet. Whenever I try to divide # of Staff Uploaded by Total Staff I get #INVALID OPERATION. I've tried it both in formula and just pluging in the numbers manually but it keeps happening. Here's what I was trying to use:
=([Staff Uploaded]10 / [Total Staff]1)
And then format the result as a percentage.
Is that correct?