percentage formula

T

Tracy

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
 
D

Dave Peterson

In AI37:

=ah37/(ag37+ah37)

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

Format as percentage.
format|cells|number tab
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

physical percentage formula 1
MS Project. Real progress of the project, % complete 1
Formula for percentage calculation 1
Percentage of Weight Loss/Gain 4
Formula to compute letter grade based on percentage grade 1
Trying to figure the formula 1
Using Excel as a markbook for attendance and assessment 1
Total percentages 2

Top