Excel Ratios and Comparing Two Cells to Determine Outcome

[sandscheng6]

I work in a church and I'm trying to determine how to monitor if our rooms with kids/teacher
ratios go over the state requirements. For instance, we can have 4 infants with 1 teacher.
So, one of our rooms had 5 kids to one teacher and I would like column C to show YES if it is
greater than 1:4, but I can't get it to work. I tried making the ratio to a percent and using
the IF statement with Column B too, to no avail. Can someone please help me? What am I missing???

A 1:4=25%	B percent	C "if A > 1:4
5:1	83.3333333333333:16.6666666666667
10:1	9.09090909090909:90.9090909090909
10.5:1	8.69565217391304:91.304347826087
15:1	6.25:93.75
13.33:1	6.97674418604651:93.0232558139535
10:1	9.09090909090909:90.9090909090909
40:1	2.4390243902439:97.5609756097561
20:1	4.76190476190476:95.2380952380952
20.33:1	4.6875:95.3125

<tbody>
</tbody>

 

[jtakw]

Hi,

No idea how your Column A and B data is populated.

Unless I'm misunderstanding your question, if you just have 2 columns, 1 for # of infants, and 1 for # of teachers, then it's pretty straight forward:

Book1
	A	B	C
1	Infants	Teacher	Need more teacher
2	5	1	Yes
3	4	1	No
4	10	1	Yes
5	21	2	Yes
6	15	1	Yes
7	3	1	No
8	40	1	Yes
9	10	1	Yes
10	40	1	Yes
11	20	1	Yes
12	61	1	Yes
Sheet555

Cell Formulas
Range	Formula
C2	=IF(B2/A2<0.25,"Yes","No")

Formula copied down.