+ Reply to Thread
Results 1 to 4 of 4

Tricky Excel Problem!!!!

  1. #1
    Registered User
    Join Date
    09-26-2018
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,522

    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.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Valued Forum Contributor
    Join Date
    05-05-2018
    Location
    Oakland, CA
    MS-Off Ver
    2016
    Posts
    655

    Re: Tricky Excel Problem!!!!

    Is this homework?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    9,223

    Re: Tricky Excel Problem!!!!

    Administrative Note:
    • We would love to continue to help you with your query, but first, before we can proceed…
    • Please see Forum Rule #1 about proper thread titles and adjust accordingly...
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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