Remember Me?

#1
August 17th 06, 12:04 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 5
DIVIDE NUMBERS EVENLY

I have a worksheet with data. I need to be able to divide a number evenly
between 6 different cells. ie: A1=349.97 then B1 thru F1 should read 58.33
but since the numbers do not divide evenly I need G1 to read 58.32. I also
been trying to figure it out on my own for the past few days!!!
Thank You,
--
NEYSA

#2
August 17th 06, 12:18 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 8,856
DIVIDE NUMBERS EVENLY

Put this formula in B1:

=ROUND(\$A1/6,2)

and copy to cells C1:F1. Put this formula in G1:

=A1-SUM(B1:F1)

I'm not sure where H1 comes into it.

Hope this helps.

Pete

NEYS wrote:
I have a worksheet with data. I need to be able to divide a number evenly
between 6 different cells. ie: A1=349.97 then B1 thru F1 should read 58.33
but since the numbers do not divide evenly I need G1 to read 58.32. I also
been trying to figure it out on my own for the past few days!!!
Thank You,
--
NEYSA

#3
August 17th 06, 01:49 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 5
DIVIDE NUMBERS EVENLY

THANK YOU PETE_UK I WILL TRY IT
--
NEYSA

"Pete_UK" wrote:

Put this formula in B1:

=ROUND(\$A1/6,2)

and copy to cells C1:F1. Put this formula in G1:

=A1-SUM(B1:F1)

I'm not sure where H1 comes into it.

Hope this helps.

Pete

NEYS wrote:
I have a worksheet with data. I need to be able to divide a number evenly
between 6 different cells. ie: A1=349.97 then B1 thru F1 should read 58.33
but since the numbers do not divide evenly I need G1 to read 58.32. I also
been trying to figure it out on my own for the past few days!!!
Thank You,
--
NEYSA

#4
August 17th 06, 01:56 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 5
DIVIDE NUMBERS EVENLY

i THINK IT IS WORKING BUT NOW I WANT THE FIGURES TO SHOW UP IN C1 ONLY IF I
ENTER A DATE INTO B1 IE IF B1 IS BLANK THEN C1 SHOULD BE BLANK, IF 8/19/06 IS
ENTEREDINTO B1 THEN C1 SHOULD HAVE A NUMBER ACCORDING TO THE FORMULA ENTERED.
THANK YOU THANK YOU
--
NEYSA

"NEYS" wrote:

I have a worksheet with data. I need to be able to divide a number evenly
between 6 different cells. ie: A1=349.97 then B1 thru F1 should read 58.33
but since the numbers do not divide evenly I need G1 to read 58.32. I also
been trying to figure it out on my own for the past few days!!!
Thank You,
--
NEYSA

#5
August 17th 06, 02:12 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 5
DIVIDE NUMBERS EVENLY

SORRY 1 MORE PROBLEM, H1 NEEDS TO BE BLANK OR ZERO IF THE A1 IS DVIDED INTO
ALL CELLS EVENLY HOWEVER IT IS SHOWING #VALUE! INSTEAD. I AM NOT SURE WHAT
PROBLEM.
--
NEYSA

"NEYS" wrote:

i THINK IT IS WORKING BUT NOW I WANT THE FIGURES TO SHOW UP IN C1 ONLY IF I
ENTER A DATE INTO B1 IE IF B1 IS BLANK THEN C1 SHOULD BE BLANK, IF 8/19/06 IS
ENTEREDINTO B1 THEN C1 SHOULD HAVE A NUMBER ACCORDING TO THE FORMULA ENTERED.
THANK YOU THANK YOU
--
NEYSA

"NEYS" wrote:

I have a worksheet with data. I need to be able to divide a number evenly
between 6 different cells. ie: A1=349.97 then B1 thru F1 should read 58.33
but since the numbers do not divide evenly I need G1 to read 58.32. I also
been trying to figure it out on my own for the past few days!!!
Thank You,
--
NEYSA

#6
August 17th 06, 08:48 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 1
DIVIDE NUMBERS EVENLY

It is also unclear what you want in H1 if they are equal blank is no
problem, but if they are not equal what do you wish to do. this assumes
b1 is a date, in your origianl post it is a1/6 but guess that is a
typo.

in c1 if(b10,round(\$a1/6,2),"")
in G1 if(b10,a1-sum(c1-f1),"")
in H1 If(b1=max(c1:f1),"",what do you want to do if it is not true?)

Regards

Dav

--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post rhon101 Excel Worksheet Functions 0 May 17th 06 02:46 AM KBear Excel Discussion (Misc queries) 2 April 21st 06 01:40 PM VLOOKUP - Numbers stored as text Excel Worksheet Functions 0 March 31st 06 05:53 PM Ann Excel Discussion (Misc queries) 4 May 18th 05 10:55 AM confused on the tundra Excel Discussion (Misc queries) 5 December 18th 04 11:19 PM

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