Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
rhon101
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
tim m
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default 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
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
How do I sum text cells with number cells? meliswi3 Excel Worksheet Functions 1 March 29th 06 10:06 PM
sum previous x number of cells neda5 Excel Discussion (Misc queries) 2 February 28th 06 01:37 AM
Formula for counting number of cells Pawan Excel Discussion (Misc queries) 2 February 22nd 06 06:20 AM
Divide number and add remainder in another cell rhon101 Excel Discussion (Misc queries) 4 November 30th 05 03:02 AM
Counting the total number of cells with specified condition(freque Kelvin Excel Discussion (Misc queries) 2 July 10th 05 12:22 PM


All times are GMT +1. The time now is 02:53 PM.

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"