Allocating the numbers from the total
 

I have numbers from Column A1:E5, In Column F1(Total) i manully enter some
numbers
in the column A1:E1 it has to change automatically to the total of F1
For E.g IN column F1(Total) i enter 64.6, the rest of the colum from A1:E1
it has to adjust automatically to the number which i have entered in column
F1(Total) and so on...
Total
70.9 -60.0 71.0 0.0 -17.3 64.6
70.7 35.0 74.0 0.0 -17.3 162.4
70.2 -65.7 68.8 0.0 -17.4 55.9
68.8 25.0 67.8 0.0 -17.1 144.4
63.0 -65.0 63.2 0.0 -16.7 44.4
can anyone please help me in this, Thanks in advance

Allocating the numbers from the total
 

I think you're going to have to give us the logic of how each item is
calculated or do you just want a straight percentage of the original 64.6.
Without that logic, you could enter any number and I'd just change the first
value to get you want ever you needed.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"srpavar" wrote:

I have numbers from Column A1:E5, In Column F1(Total) i manully enter some
numbers
in the column A1:E1 it has to change automatically to the total of F1
For E.g IN column F1(Total) i enter 64.6, the rest of the colum from A1:E1
it has to adjust automatically to the number which i have entered in column
F1(Total) and so on...
Total
70.9 -60.0 71.0 0.0 -17.3 64.6
70.7 35.0 74.0 0.0 -17.3 162.4
70.2 -65.7 68.8 0.0 -17.4 55.9
68.8 25.0 67.8 0.0 -17.1 144.4
63.0 -65.0 63.2 0.0 -16.7 44.4
can anyone please help me in this, Thanks in advance