Discussion Re: Switching 500% to 100% in Excel? in Excel
https://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3417828#M147719
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?Mon, 23 May 2022 23:24:10 GMTmathetes2022-05-23T23:24:10ZSwitching 500% to 100% in Excel?
https://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3417737#M147718
<P>I have an equation as follows:</P><P>I have 5 daily tasks, which I would like to complete, and Excel will convert them to 100%.</P><P>I do not have enough knowledge to deal with it, yet the result appears to me 500%????!</P>Mon, 23 May 2022 22:57:36 GMThttps://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3417737#M147718fahadsalama2022-05-23T22:57:36ZRe: Switching 500% to 100% in Excel?
https://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3417828#M147719
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?Mon, 23 May 2022 23:24:10 GMThttps://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3417828#M147719mathetes2022-05-23T23:24:10ZRe: Switching 500% to 100% in Excel?
https://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3419060#M147753
Thanks<BR /><BR /><BR /><BR />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.Tue, 24 May 2022 07:45:04 GMThttps://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3419060#M147753fahadsalama2022-05-24T07:45:04ZRe: Switching 500% to 100% in Excel?
https://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3419633#M147768
<P><LI-USER uid="1399068"></LI-USER> </P>
<P>Let's say that F2 contains the number of completed tasks (0 ... 5).</P>
<P>In the cell next to it, enter the formula =F2/5 and format this cell as a percentage.</P>
<P>This can be filled down.</P>Tue, 24 May 2022 10:11:26 GMThttps://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3419633#M147768Hans Vogelaar2022-05-24T10:11:26ZRe: Switching 500% to 100% in Excel?
https://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3419875#M147777
Thank you. Thanks Microsoft community.Tue, 24 May 2022 11:04:05 GMThttps://techcommunity.microsoft.com/t5/excel/switching-500-to-100-in-excel/m-p/3419875#M147777fahadsalama2022-05-24T11:04:05Z