| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allocating usage across aging buckets | Excel Worksheet Functions | |||
| Allocating a value from a cell | Excel Worksheet Functions | |||
| allocating between positive and negative amounts | Excel Worksheet Functions | |||
| Allocating a Value | Excel Worksheet Functions | |||
| how do I add a list of numbers to get a total | Excel Discussion (Misc queries) | |||
Threaded Mode
