# Tricky Excel Problem!!!!

1. ## Tricky Excel Problem!!!!

Hello,

I need to figure out the following using the attached info. What formula(s) should I use to do this?

The City Council wants to fund an additional 50 certified Health Education teachers across 8 districts in high schools with more than 500 students that currently do not have a certified Health Education teacher. Using the chart below, provide recommendations on the most equitable way to place the 50 new certified Health Education teachers across these districts, and include how many each district should receive.

2. ## Re: Tricky Excel Problem!!!!

Enter this formula in D2 and Fill down =ROUND(50*C2/C\$10,0)

Enter this formula in D10 =SUM(D2:D9)

The result is 49. Leaving One Spare Teacher. That Teacher should be assigned to District 43, Which has the biggest need.

3. ## Re: Tricky Excel Problem!!!!

Is this homework?

4. ## Re: Tricky Excel Problem!!!!

• We would love to continue to help you with your query, but first, before we can proceed…

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1