SOLVED

New Contributor

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 me 500%????!

4 Replies

Re: Switching 500% to 100% in Excel?

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?

Re: Switching 500% to 100% in Excel?

Thanks

5 daily tasks. At the end of the day on completion it gives me the total of the tasks completed and the level of achievement %, whether one task or all five. I would like to address Excel: to convert any number of the total tasks performed into a percentage. If 5 = 100%, if 4 = 80%, if 3 = 60%, if 2 = 40%, if 1 = 20%, if 0="" and so on.
best response confirmed by fahadsalama (New Contributor)
Solution

Re: Switching 500% to 100% in Excel?

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.

Re: Switching 500% to 100% in Excel?

Thank you. Thanks Microsoft community.