+ Reply to Thread
Results 1 to 4 of 4

Tricky Excel Problem!!!!

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Tricky Excel Problem!!!!


    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 Guru
    Join Date
    London England
    MS-Off Ver
    MS 365 Office Suite.

    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
    Oakland, CA
    MS-Off Ver

    Re: Tricky Excel Problem!!!!

    Is this homework?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    Cibolo, TX
    MS-Off Ver
    Excel 2016

    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...
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-14-2017, 03:06 AM
  2. Tricky Problem
    By leao67 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-06-2014, 12:39 AM
  3. Very Tricky problem in EXCEL
    By sramidi in forum Excel General
    Replies: 1
    Last Post: 01-23-2012, 05:31 AM
  4. Tricky Excel mailout problem...
    By Whizzo in forum Excel General
    Replies: 1
    Last Post: 04-07-2009, 08:37 AM
  5. Tricky problem in Data validation - Excel 2003
    By smadhuranath in forum Excel General
    Replies: 1
    Last Post: 07-18-2006, 04:15 AM
  6. [SOLVED] tricky SQL problem using VBA Excel to read Access File
    By nrgguy@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2006, 06:55 PM
  7. Tricky Problem
    By pytelium in forum Excel General
    Replies: 6
    Last Post: 08-13-2005, 05:44 PM


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