Results 1 to 7 of 7

nesting issue involving percentages

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2010
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    4

    Angry nesting issue involving percentages

    I have tried an array of math to the following percentage issue to no avail. I have 4 cells. 1 is for positive credits B10 and one is for total pool A10. In this case the goal is 70%. I have a cell A51 which subtracts B10 from A10 to give the total negatives. B51 is the kicker. I need to use the information above to determine how many have to be added to both the credit and the pool to get 70%. First I decided to use IF statements ie; IF(B10/A10)>.69,""(IF((B10+1)/(A10+1)>.69,1,(IF((B10+2)/(A10+2)>.69,2,(IF....and so on...this seems like stone wheel days to me and there must be an easier way..It will only let me go to 7 due to nesting issues anyway. Anyone know the correct math? If I started with 5 credits and 12 in the total pool (41.7%) I know that I would have to add 12 to both the credit and total pool or 17/24 to get to 70%. I would like cell B51 to indicate 12 needed to meet goal...help
    Last edited by statictwist; 06-10-2010 at 12:41 PM.

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