Shadowgaze
New Member
- Joined
- Oct 13, 2015
- Messages
- 5
I love excel and use it for all my business needs ive recently made a very large workbook with many calculations and they all work the way i want. save for one section! i for the life of me cannot get this to calculate correctly. please help me!
here is what i am attempting
i need to count children at my daycare and then use 4 different ratios to figure out how many teachers i need to have in attendance normally this would be simple except if the ratio is not a whole number you need to combine kids from a lower ratio to a higher ratio and the higher ratio must now take on the ratio of the lower ratio kids
IE the ratio for infants is 4 to 1 and toddlers is 6 to 1..... if i have 6 infants and 5 toddlers .... 2 of the toddlers need to be counted as infants to get the infants to a whole number and the remainder of toddlers can be counted at the toddler raitio
so
4 infants = 1 teacher
2 infants + 2 Toddlers = 1 Teacher
3 remaining Toddlers = 1 Teacher

img host
sometimes the calculations are right but they are NOT all the time and its causing allot of unessential problems at work
i know its probably something easy but i cannot figure it out please help!
here is what i am attempting
i need to count children at my daycare and then use 4 different ratios to figure out how many teachers i need to have in attendance normally this would be simple except if the ratio is not a whole number you need to combine kids from a lower ratio to a higher ratio and the higher ratio must now take on the ratio of the lower ratio kids
IE the ratio for infants is 4 to 1 and toddlers is 6 to 1..... if i have 6 infants and 5 toddlers .... 2 of the toddlers need to be counted as infants to get the infants to a whole number and the remainder of toddlers can be counted at the toddler raitio
so
4 infants = 1 teacher
2 infants + 2 Toddlers = 1 Teacher
3 remaining Toddlers = 1 Teacher

img host
sometimes the calculations are right but they are NOT all the time and its causing allot of unessential problems at work

i know its probably something easy but i cannot figure it out please help!