LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 12
Default Divide a # into 3 #'s rounded to a whole #

I have a Cost that must be divided into 3 separate percentages that my company can bill against. We don't like to input any budget numbers into our accounting system that contain cents, so we round all of our numbers up or down manually so that they may be added up to equal the original total.

So if I have a cost of $17, and I have to divide it into 3 numbers (15%, 35%, & 50%), how can i create three separate formulas to automatically round the 3 numbers to the nearest whole dollar and still create a sum of $17?

Assume $17 = H35, 15% = H6, 35% = H7, & 50% = H8
I tried the following, which seems to not work for all total numbers:
=Rounddown(H35*H6,0)
=Roundup(H35*H7,0)
=Rounddown(H35*H8,0)

Any help would be appreciated
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add rounded numbers using the rounded value Ruth Excel Discussion (Misc queries) 2 February 8th 10 07:59 PM
ROUNDED NUMBERS rajaiy Excel Worksheet Functions 2 January 28th 09 02:15 PM
Rounded Rectangle Adrian D. Bailey Excel Programming 3 March 26th 07 05:58 PM
Divide one row over other row I dont wont to divide one number Rick Excel Discussion (Misc queries) 0 March 4th 05 07:13 PM
Divide Expression stops in Macro when Can't divide JUAN Excel Programming 6 May 6th 04 07:05 AM


All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"