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 |
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