Results 1 to 7 of 7

multiply a number by percentages and round so that they add upto the total %

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2009
    Location
    kerala, india
    MS-Off Ver
    Excel 2003
    Posts
    20

    multiply a number by percentages and round so that they add upto the total %

    I want to multiply a number say, 1551 by 5%, 6%, 7%, 8% and 9% and round each result to 0 decimal places. Then the sum of these results (544)should be equal to 35% of 1551 rounded to 0 decimal places (543). How do I create an if function for rounding so that the sum equals 543.
    Last edited by dittotharappel; 03-28-2009 at 12:06 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