Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Divide a number into multiple cells
I need to divide a number into multiple cells accurately. All results should
equal the divided number if summed. An odd number for example; 455 divided into 4 cells should return 114, 114, 114, 113. Or an even number; 424 divided into 4 different cells returning 212, 212, 212, 212. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Divide a number into multiple cells
The question is do the numbers have to be rounded up or down to whole numbers
or can they be decimals? If 455 was in cell A1 you could copy this forumla into four cells =$A$1/4 which would give you 113.75, a sum of those 4 cells = 455 "rhon101" wrote: I need to divide a number into multiple cells accurately. All results should equal the divided number if summed. An odd number for example; 455 divided into 4 cells should return 114, 114, 114, 113. Or an even number; 424 divided into 4 different cells returning 212, 212, 212, 212. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Divide a number into multiple cells
Hi!
It looks like you want whole numbers as results. What result would expect from 286? 72....72....72....70 = 286 A1 = some number Enter this formula in B1 and copy across to E1: =IF(COLUMNS($A:A)<4,ROUND($A1/4,0),$A1-ROUND($A1/4,0)*3) Biff "rhon101" wrote in message ... I need to divide a number into multiple cells accurately. All results should equal the divided number if summed. An odd number for example; 455 divided into 4 cells should return 114, 114, 114, 113. Or an even number; 424 divided into 4 different cells returning 212, 212, 212, 212. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sum text cells with number cells? | Excel Worksheet Functions | |||
sum previous x number of cells | Excel Discussion (Misc queries) | |||
Formula for counting number of cells | Excel Discussion (Misc queries) | |||
Divide number and add remainder in another cell | Excel Discussion (Misc queries) | |||
Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) |