Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 47
Default how do you divide the average of a number into 3 different cells.

i am trying to do a stock and order for work. i have to divide the amount of
sales by the quantity of units in a case to come up with ( cases required to
order). i have done that but i need to average that total into to three
cells. e.g 12 = 4 4 4, 11 = 4 4 3
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default how do you divide the average of a number into 3 different cells.


Assuming you want the last column to be the "catch" column, that is it
will either be higher or lower than the other two columns by one if the
number is not divisible by three evenly you can try the following:


Code:
--------------------
Row Col A Col B Col C Col D
11 11 =MROUND(A11,3)/3 =MROUND(A11,3)/3 =MROUND(A11,3)/3-(MROUND(A11,3)-A11)
12 12 =MROUND(A12,3)/3 =MROUND(A12,3)/3 =MROUND(A12,3)/3-(MROUND(A12,3)-A12)
13 13 =MROUND(A13,3)/3 =MROUND(A13,3)/3 =MROUND(A13,3)/3-(MROUND(A13,3)-A13)
--------------------


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=564899

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 427
Default how do you divide the average of a number into 3 different cells.

On Tue, 25 Jul 2006 21:44:02 +0100, Shaun
wrote:

i am trying to do a stock and order for work. i have to divide the
amount of
sales by the quantity of units in a case to come up with ( cases
required to
order). i have done that but i need to average that total into to three
cells. e.g 12 = 4 4 4, 11 = 4 4 3


don't use the word average - confusing.

You want to split or spread

if A5 = 12
then B5 = roundup(a5/3,0)
c5 = roundup(a5/3,0)
d5 = a5-b5-c5

This gives odd result for 10, ie 4,4,2
and for 9 result is 3,3,3

If this is acceptable
otherwise
change c5 = roundup((a5-b5)/2,0)
not 10 produces 4,3,3



--
Steve (3)
Reply
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
average price of 4 columns of figures but some cells can be blank bpeltzer Excel Worksheet Functions 0 February 13th 06 09:37 PM
30 Day Moving Average Ignoring Blank Cells ethatch Excel Worksheet Functions 2 January 17th 06 10:37 AM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM
How do I ignore cells with errors when calculating an average? M Enfroy Excel Worksheet Functions 6 November 1st 05 04:26 PM
Average Non-Continuous Cells Without Zero's raeleanne Excel Worksheet Functions 8 July 22nd 05 02:48 PM


All times are GMT +1. The time now is 10:05 AM.

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

About Us

"It's about Microsoft Excel"