Forum Discussion
Solved
Switching 500% to 100% in Excel?
I have an equation as follows: I have 5 daily tasks, which I would like to complete, and Excel will convert them to 100%. I do not have enough knowledge to deal with it, yet the result appears to m...
Let's say that F2 contains the number of completed tasks (0 ... 5).
In the cell next to it, enter the formula =F2/5 and format this cell as a percentage.
This can be filled down.
What's the equation (by which I assume you mean formula) that you have? Any way you could take a picture of the spreadsheet as well as share the formula you've written that is producing that "500%" result?