+ Reply to Thread
Results 1 to 2 of 2

multiple evaluations in one formula utilizing percentages

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    multiple evaluations in one formula utilizing percentages

    In the attached worksheet, for the value in cell C3, I want to project how many of the cities contracted will fall into each of the categories in cells B72- B75. I would then want to multiply the corresponding value in cells C72-C75 and add the four products together to determine the projected amount of licensing fees for the month
    • Assume 30% of the cities under contract will meet the criteria established in B72
    • 30% will meet B73
    • 30% will meet B74
    • And finally, 10% will meet B75

    Also, is it possible for whole numbers to line up with the accounting numbers? You can see the issue in rows 2 – 10. Or is it supposed to look like that to differentiate between the two types of values?

    Hope I explained it well!
    Attached Files Attached Files
    Last edited by hmoorex3; 02-21-2013 at 05:01 PM.

  2. #2
    Registered User
    Join Date
    02-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: multiple evaluations in one formula utilizing percentages

    Really? Almost 100 people viewed this posting in over two weeks and not one single reply?

    I'll head over to Chandoo.org....

+ 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