ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   percentage formula (https://www.excelbanter.com/excel-discussion-misc-queries/20515-percentage-formula.html)

Tracy

percentage formula
 
I need help with a formula for percentage of the time kids are in class....

AG37 is Absent
AH37 is present
AI37 is the percentage of time they are there????

That is my problem, I have tried but it doesn't come out right.... Thanks
Tracy

Dave Peterson

In AI37:

=ah37/(ag37+ah37)

=present/(absent+present)
=present/(total days)

Format as percentage.
format|cells|number tab

Tracy wrote:

I need help with a formula for percentage of the time kids are in class....

AG37 is Absent
AH37 is present
AI37 is the percentage of time they are there????

That is my problem, I have tried but it doesn't come out right.... Thanks
Tracy


--

Dave Peterson


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com