DIVIDE NUMBERS EVENLY

N

NEYS

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
need H1 to read 0.00 or blank. Please, please, please I need help I have
been trying to figure it out on my own for the past few days!!!
Thank You,
 
P

Pete_UK

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
 
N

NEYS

THANK YOU PETE_UK I WILL TRY IT
--
NEYSA


Pete_UK said:
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
 
N

NEYS

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
FORMULA TO USE PLEASE PLEASE PLEASE HELP ME I AM GETTING FRUSTRATED WITH THIS
PROBLEM.
 
D

Dav

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(b1>0,round($a1/6,2),"")
in G1 if(b1>0,a1-sum(c1-f1),"")
in H1 If(b1=max(c1:f1),"",what do you want to do if it is not true?)

Regards

Dav
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top