| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate a percentage formula with existing data? | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| How do I create a formula to calculate the average percentage rat | Excel Worksheet Functions | |||
| Percentage formula | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Linear Mode
